diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/create_function_3.out | 42 | ||||
| -rw-r--r-- | src/test/regress/sql/create_function_3.sql | 24 |
2 files changed, 1 insertions, 65 deletions
diff --git a/src/test/regress/expected/create_function_3.out b/src/test/regress/expected/create_function_3.out index e77799ac4e9..8dceb762e1b 100644 --- a/src/test/regress/expected/create_function_3.out +++ b/src/test/regress/expected/create_function_3.out @@ -99,43 +99,6 @@ SELECT proname, prosecdef FROM pg_proc (3 rows) -- --- COST --- -CREATE FUNCTION functext_D_1(int,int) RETURNS int LANGUAGE 'sql' - AS 'SELECT $1 + $2'; -CREATE FUNCTION functext_D_2(int,int) RETURNS int LANGUAGE 'internal' - AS 'int4pl'; -CREATE FUNCTION functext_D_3(int,int) RETURNS int LANGUAGE 'sql' - COST 500 AS 'SELECT $1 * $2'; -CREATE FUNCTION functext_D_4(int,int) RETURNS int LANGUAGE 'sql' - COST 0 AS 'SELECT $1 / $2'; -- Error -ERROR: COST must be positive -SELECT proname, procost FROM pg_proc - WHERE oid in ('functext_D_1'::regproc, - 'functext_D_2'::regproc, - 'functext_D_3'::regproc) ORDER BY proname; - proname | procost ---------------+--------- - functext_d_1 | 100 - functext_d_2 | 1 - functext_d_3 | 500 -(3 rows) - -ALTER FUNCTION functext_D_1(int,int) STABLE; -- unrelated change, no effect -ALTER FUNCTION functext_D_2(int,int) COST 50; -ALTER FUNCTION functext_D_3(int,int) COST 0.0001; -SELECT proname, procost FROM pg_proc - WHERE oid in ('functext_D_1'::regproc, - 'functext_D_2'::regproc, - 'functext_D_3'::regproc) ORDER BY proname; - proname | procost ---------------+--------- - functext_d_1 | 100 - functext_d_2 | 50 - functext_d_3 | 0.0001 -(3 rows) - --- -- LEAKPROOF -- CREATE FUNCTION functext_E_1(int) RETURNS bool LANGUAGE 'sql' @@ -440,7 +403,7 @@ SELECT proname, proisstrict FROM pg_proc -- Cleanups DROP SCHEMA temp_func_test CASCADE; -NOTICE: drop cascades to 19 other objects +NOTICE: drop cascades to 16 other objects DETAIL: drop cascades to function functest_a_1(text,date) drop cascades to function functest_a_2(text[]) drop cascades to function functest_a_3() @@ -451,9 +414,6 @@ drop cascades to function functest_b_4(integer) drop cascades to function functext_c_1(integer) drop cascades to function functext_c_2(integer) drop cascades to function functext_c_3(integer) -drop cascades to function functext_d_1(integer,integer) -drop cascades to function functext_d_2(integer,integer) -drop cascades to function functext_d_3(integer,integer) drop cascades to function functext_e_1(integer) drop cascades to function functext_e_2(integer) drop cascades to function functext_f_1(integer) diff --git a/src/test/regress/sql/create_function_3.sql b/src/test/regress/sql/create_function_3.sql index f895aaa1a9e..56ed215a288 100644 --- a/src/test/regress/sql/create_function_3.sql +++ b/src/test/regress/sql/create_function_3.sql @@ -69,30 +69,6 @@ SELECT proname, prosecdef FROM pg_proc 'functext_C_3'::regproc) ORDER BY proname; -- --- COST --- -CREATE FUNCTION functext_D_1(int,int) RETURNS int LANGUAGE 'sql' - AS 'SELECT $1 + $2'; -CREATE FUNCTION functext_D_2(int,int) RETURNS int LANGUAGE 'internal' - AS 'int4pl'; -CREATE FUNCTION functext_D_3(int,int) RETURNS int LANGUAGE 'sql' - COST 500 AS 'SELECT $1 * $2'; -CREATE FUNCTION functext_D_4(int,int) RETURNS int LANGUAGE 'sql' - COST 0 AS 'SELECT $1 / $2'; -- Error -SELECT proname, procost FROM pg_proc - WHERE oid in ('functext_D_1'::regproc, - 'functext_D_2'::regproc, - 'functext_D_3'::regproc) ORDER BY proname; - -ALTER FUNCTION functext_D_1(int,int) STABLE; -- unrelated change, no effect -ALTER FUNCTION functext_D_2(int,int) COST 50; -ALTER FUNCTION functext_D_3(int,int) COST 0.0001; -SELECT proname, procost FROM pg_proc - WHERE oid in ('functext_D_1'::regproc, - 'functext_D_2'::regproc, - 'functext_D_3'::regproc) ORDER BY proname; - --- -- LEAKPROOF -- CREATE FUNCTION functext_E_1(int) RETURNS bool LANGUAGE 'sql' |