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