diff options
Diffstat (limited to 'src/test/regress/output/create_function_1.source')
| -rw-r--r-- | src/test/regress/output/create_function_1.source | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/src/test/regress/output/create_function_1.source b/src/test/regress/output/create_function_1.source index 44e74fb527..e3886febaa 100644 --- a/src/test/regress/output/create_function_1.source +++ b/src/test/regress/output/create_function_1.source @@ -52,16 +52,20 @@ CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql AS 'SELECT ''not an integer'';'; ERROR: return type mismatch in function declared to return integer DETAIL: Actual return type is "unknown". +CONTEXT: SQL function "test1" CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql AS 'not even SQL'; ERROR: syntax error at or near "not" at character 1 +CONTEXT: SQL function "test1" CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql AS 'SELECT 1, 2, 3;'; ERROR: return type mismatch in function declared to return integer DETAIL: Final SELECT must return exactly one column. +CONTEXT: SQL function "test1" CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql AS 'SELECT $2;'; ERROR: there is no parameter $2 +CONTEXT: SQL function "test1" CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql AS 'a', 'b'; ERROR: only one AS item needed for language "sql" |