diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/create_procedure.out | 7 | ||||
| -rw-r--r-- | src/test/regress/sql/create_procedure.sql | 11 |
2 files changed, 18 insertions, 0 deletions
diff --git a/src/test/regress/expected/create_procedure.out b/src/test/regress/expected/create_procedure.out index 30495971bc8..0acea7bd8c7 100644 --- a/src/test/regress/expected/create_procedure.out +++ b/src/test/regress/expected/create_procedure.out @@ -116,6 +116,13 @@ SELECT * FROM cp_test; 100 | Hello (8 rows) +-- polymorphic types +CREATE PROCEDURE ptest6(a int, b anyelement) +LANGUAGE SQL +AS $$ +SELECT NULL::int; +$$; +CALL ptest6(1, 2); -- various error cases CALL version(); -- error: not a procedure ERROR: version() is not a procedure diff --git a/src/test/regress/sql/create_procedure.sql b/src/test/regress/sql/create_procedure.sql index 22cc497ebee..0a9af8c9063 100644 --- a/src/test/regress/sql/create_procedure.sql +++ b/src/test/regress/sql/create_procedure.sql @@ -84,6 +84,17 @@ CALL ptest5(b => 'Hello', a => 10); SELECT * FROM cp_test; +-- polymorphic types + +CREATE PROCEDURE ptest6(a int, b anyelement) +LANGUAGE SQL +AS $$ +SELECT NULL::int; +$$; + +CALL ptest6(1, 2); + + -- various error cases CALL version(); -- error: not a procedure |