1--
2-- regproc
3--
4
5/* If objects exist, return oids */
6
7CREATE ROLE regress_regrole_test;
8
9-- without schemaname
10
11SELECT regoper('||/');
12SELECT regoperator('+(int4,int4)');
13SELECT regproc('now');
14SELECT regprocedure('abs(numeric)');
15SELECT regclass('pg_class');
16SELECT regtype('int4');
17
18SELECT to_regoper('||/');
19SELECT to_regoperator('+(int4,int4)');
20SELECT to_regproc('now');
21SELECT to_regprocedure('abs(numeric)');
22SELECT to_regclass('pg_class');
23SELECT to_regtype('int4');
24
25-- with schemaname
26
27SELECT regoper('pg_catalog.||/');
28SELECT regoperator('pg_catalog.+(int4,int4)');
29SELECT regproc('pg_catalog.now');
30SELECT regprocedure('pg_catalog.abs(numeric)');
31SELECT regclass('pg_catalog.pg_class');
32SELECT regtype('pg_catalog.int4');
33
34SELECT to_regoper('pg_catalog.||/');
35SELECT to_regproc('pg_catalog.now');
36SELECT to_regprocedure('pg_catalog.abs(numeric)');
37SELECT to_regclass('pg_catalog.pg_class');
38SELECT to_regtype('pg_catalog.int4');
39
40-- schemaname not applicable
41
42SELECT regrole('regress_regrole_test');
43SELECT regrole('"regress_regrole_test"');
44SELECT regnamespace('pg_catalog');
45SELECT regnamespace('"pg_catalog"');
46
47SELECT to_regrole('regress_regrole_test');
48SELECT to_regrole('"regress_regrole_test"');
49SELECT to_regnamespace('pg_catalog');
50SELECT to_regnamespace('"pg_catalog"');
51
52/* If objects don't exist, raise errors. */
53
54DROP ROLE regress_regrole_test;
55
56-- without schemaname
57
58SELECT regoper('||//');
59SELECT regoperator('++(int4,int4)');
60SELECT regproc('know');
61SELECT regprocedure('absinthe(numeric)');
62SELECT regclass('pg_classes');
63SELECT regtype('int3');
64
65-- with schemaname
66
67SELECT regoper('ng_catalog.||/');
68SELECT regoperator('ng_catalog.+(int4,int4)');
69SELECT regproc('ng_catalog.now');
70SELECT regprocedure('ng_catalog.abs(numeric)');
71SELECT regclass('ng_catalog.pg_class');
72SELECT regtype('ng_catalog.int4');
73
74-- schemaname not applicable
75
76SELECT regrole('regress_regrole_test');
77SELECT regrole('"regress_regrole_test"');
78SELECT regrole('Nonexistent');
79SELECT regrole('"Nonexistent"');
80SELECT regrole('foo.bar');
81SELECT regnamespace('Nonexistent');
82SELECT regnamespace('"Nonexistent"');
83SELECT regnamespace('foo.bar');
84
85/* If objects don't exist, return NULL with no error. */
86
87-- without schemaname
88
89SELECT to_regoper('||//');
90SELECT to_regoperator('++(int4,int4)');
91SELECT to_regproc('know');
92SELECT to_regprocedure('absinthe(numeric)');
93SELECT to_regclass('pg_classes');
94SELECT to_regtype('int3');
95
96-- with schemaname
97
98SELECT to_regoper('ng_catalog.||/');
99SELECT to_regoperator('ng_catalog.+(int4,int4)');
100SELECT to_regproc('ng_catalog.now');
101SELECT to_regprocedure('ng_catalog.abs(numeric)');
102SELECT to_regclass('ng_catalog.pg_class');
103SELECT to_regtype('ng_catalog.int4');
104
105-- schemaname not applicable
106
107SELECT to_regrole('regress_regrole_test');
108SELECT to_regrole('"regress_regrole_test"');
109SELECT to_regrole('foo.bar');
110SELECT to_regrole('Nonexistent');
111SELECT to_regrole('"Nonexistent"');
112SELECT to_regrole('foo.bar');
113SELECT to_regnamespace('Nonexistent');
114SELECT to_regnamespace('"Nonexistent"');
115SELECT to_regnamespace('foo.bar');
116