diff options
Diffstat (limited to 'src/test/regress/input/create_function_2.source')
-rw-r--r-- | src/test/regress/input/create_function_2.source | 70 |
1 files changed, 0 insertions, 70 deletions
diff --git a/src/test/regress/input/create_function_2.source b/src/test/regress/input/create_function_2.source deleted file mode 100644 index 4bcf24c6011..00000000000 --- a/src/test/regress/input/create_function_2.source +++ /dev/null @@ -1,70 +0,0 @@ --- --- CREATE_FUNCTION_2 --- -CREATE FUNCTION hobbies(person) - RETURNS setof hobbies_r - AS 'select * from hobbies_r where person = $1.name' - LANGUAGE 'sql'; - - -CREATE FUNCTION hobby_construct(text, text) - RETURNS hobbies_r - AS 'select $1 as name, $2 as hobby' - 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' - LANGUAGE 'sql'; - - -CREATE FUNCTION user_relns() - RETURNS setof name - AS 'select relname - from pg_class - where relname !~ ''pg_.*'' and - relkind <> ''i'' ' - LANGUAGE 'sql'; - -CREATE FUNCTION pt_in_widget(point, widget) - RETURNS bool - AS '@abs_builddir@/regress@DLSUFFIX@' - LANGUAGE 'C'; - -CREATE FUNCTION overpaid(emp) - RETURNS bool - AS '@abs_builddir@/regress@DLSUFFIX@' - LANGUAGE 'C'; - -CREATE FUNCTION boxarea(box) - RETURNS float8 - AS '@abs_builddir@/regress@DLSUFFIX@' - LANGUAGE 'C'; - -CREATE FUNCTION interpt_pp(path, path) - RETURNS point - AS '@abs_builddir@/regress@DLSUFFIX@' - LANGUAGE 'C'; - -CREATE FUNCTION reverse_name(name) - RETURNS name - AS '@abs_builddir@/regress@DLSUFFIX@' - LANGUAGE 'c'; - -CREATE FUNCTION oldstyle_length(int4, text) - RETURNS int4 - AS '@abs_builddir@/regress@DLSUFFIX@' - LANGUAGE 'c'; - --- --- Function dynamic loading --- -LOAD '@abs_builddir@/regress@DLSUFFIX@'; - |