4 CREATE FUNCTION hobbies(person)
5 RETURNS setof hobbies_r
6 AS 'select * from hobbies_r where person = $1.name'
10 CREATE FUNCTION hobby_construct(text, text)
12 AS 'select $1 as name, $2 as hobby'
16 CREATE FUNCTION hobbies_by_name(hobbies_r.name%TYPE)
17 RETURNS hobbies_r.person%TYPE
18 AS 'select person from hobbies_r where name = $1'
22 CREATE FUNCTION equipment(hobbies_r)
23 RETURNS setof equipment_r
24 AS 'select * from equipment_r where hobby = $1.name'
28 CREATE FUNCTION user_relns()
31 from pg_class c, pg_namespace n
32 where relnamespace = n.oid and
33 (nspname !~ ''pg_.*'' and nspname <> ''information_schema'') and
37 CREATE FUNCTION pt_in_widget(point, widget)
39 AS '@libdir@/regress@DLSUFFIX@'
42 CREATE FUNCTION overpaid(emp)
44 AS '@libdir@/regress@DLSUFFIX@'
47 CREATE FUNCTION boxarea(box)
49 AS '@libdir@/regress@DLSUFFIX@'
52 CREATE FUNCTION interpt_pp(path, path)
54 AS '@libdir@/regress@DLSUFFIX@'
57 CREATE FUNCTION reverse_name(name)
59 AS '@libdir@/regress@DLSUFFIX@'
62 CREATE FUNCTION oldstyle_length(int4, text)
64 AS '@libdir@/regress@DLSUFFIX@'
68 -- Function dynamic loading
70 LOAD '@libdir@/regress@DLSUFFIX@';