diff options
| author | Marc G. Fournier <scrappy@hub.org> | 1997-04-06 08:29:57 +0000 |
|---|---|---|
| committer | Marc G. Fournier <scrappy@hub.org> | 1997-04-06 08:29:57 +0000 |
| commit | e31cb4be3adf6bce2997e03a5d0c2d61ff400730 (patch) | |
| tree | 09e1b966f8f4943937a6c9e48d598bd9d3b1d6b6 /src/test/regress/output/create_function_2.source | |
| parent | 588ae64c4402ddf6e9fc8596fa2c53453d577f73 (diff) | |
| download | postgresql-e31cb4be3adf6bce2997e03a5d0c2d61ff400730.tar.gz | |
More splits and cleanups...
Its starting to actually take shape and look as expected...
Diffstat (limited to 'src/test/regress/output/create_function_2.source')
| -rw-r--r-- | src/test/regress/output/create_function_2.source | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/src/test/regress/output/create_function_2.source b/src/test/regress/output/create_function_2.source new file mode 100644 index 0000000000..9bd0eef9d3 --- /dev/null +++ b/src/test/regress/output/create_function_2.source @@ -0,0 +1,40 @@ +QUERY: CREATE FUNCTION hobbies(person) + RETURNS setof hobbies_r + AS 'select * from hobbies_r where person = $1.name' + LANGUAGE 'sql'; +QUERY: CREATE FUNCTION hobby_construct(text, text) + RETURNS hobbies_r + AS 'select $1 as name, $2 as hobby' + LANGUAGE 'sql'; +QUERY: CREATE FUNCTION equipment(hobbies_r) + RETURNS setof equipment_r + AS 'select * from equipment_r where hobby = $1.name' + LANGUAGE 'sql'; +QUERY: CREATE FUNCTION user_relns() + RETURNS setof name + AS 'select relname + from pg_class + where relname !~ ''pg_.*'' and + relkind <> ''i'' ' + LANGUAGE 'sql'; +QUERY: CREATE FUNCTION pt_in_circle(point, circle) + RETURNS int4 + AS '_CWD_/regress_DLSUFFIX_' + LANGUAGE 'c'; +QUERY: CREATE FUNCTION overpaid(emp) + RETURNS bool + AS '_CWD_/regress_DLSUFFIX_' + LANGUAGE 'c'; +QUERY: CREATE FUNCTION boxarea(box) + RETURNS int4 + AS '_CWD_/regress_DLSUFFIX_' + LANGUAGE 'c'; +QUERY: CREATE FUNCTION interpt_pp(path, path) + RETURNS point + AS '_CWD_/regress_DLSUFFIX_' + LANGUAGE 'c'; +QUERY: CREATE FUNCTION reverse_c16(char16) + RETURNS char16 + AS '_CWD_/regress_DLSUFFIX_' + LANGUAGE 'c'; +QUERY: LOAD '_CWD_/regress_DLSUFFIX_'; |
