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 '@abs_builddir@/regress@DLSUFFIX@'
42
CREATE FUNCTION overpaid(emp)
44
AS '@abs_builddir@/regress@DLSUFFIX@'
47
CREATE FUNCTION boxarea(box)
49
AS '@abs_builddir@/regress@DLSUFFIX@'
52
CREATE FUNCTION interpt_pp(path, path)
54
AS '@abs_builddir@/regress@DLSUFFIX@'
57
CREATE FUNCTION reverse_name(name)
59
AS '@abs_builddir@/regress@DLSUFFIX@'
62
CREATE FUNCTION oldstyle_length(int4, text)
64
AS '@abs_builddir@/regress@DLSUFFIX@'
68
-- Function dynamic loading
70
LOAD '@abs_builddir@/regress@DLSUFFIX@';