diff options
Diffstat (limited to 'src/test/regress/input/create_function_2.source')
| -rw-r--r-- | src/test/regress/input/create_function_2.source | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/src/test/regress/input/create_function_2.source b/src/test/regress/input/create_function_2.source index b1c0eab1386..4bcf24c6011 100644 --- a/src/test/regress/input/create_function_2.source +++ b/src/test/regress/input/create_function_2.source @@ -13,6 +13,12 @@ CREATE FUNCTION hobby_construct(text, text) LANGUAGE 'sql'; +CREATE FUNCTION hobbies_by_name(hobbies_r.name%TYPE) + RETURNS hobbies_r.person%TYPE + AS 'select person from hobbies_r where name = $1' + LANGUAGE 'sql'; + + CREATE FUNCTION equipment(hobbies_r) RETURNS setof equipment_r AS 'select * from equipment_r where hobby = $1.name' |