| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
| H A D | object_address.sql | 53 SELECT pg_get_object_address('stone', '{}', '{}');
54 SELECT pg_get_object_address('table', '{}', '{}');
55 SELECT pg_get_object_address('table', '{NULL}', '{}');
66 PERFORM pg_get_object_address(objtype, '{one}', '{}');
115 SELECT pg_get_object_address('language', '{one}', '{}');
120 SELECT pg_get_object_address('schema', '{one}', '{}');
122 SELECT pg_get_object_address('role', '{one}', '{}');
123 SELECT pg_get_object_address('role', '{one,two}', '{}');
124 SELECT pg_get_object_address('database', '{one}', '{}');
130 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
| H A D | object_address.sql | 130 pg_get_object_address('stone', '{}', '{}');
133 pg_get_object_address('table', '{}', '{}');
136 pg_get_object_address('table', '{NULL}', '{}');
206 pg_get_object_address('language', '{one}', '{}');
221 pg_get_object_address('schema', '{one}', '{}');
227 pg_get_object_address('role', '{one}', '{}');
230 pg_get_object_address('role', '{one,two}', '{}');
233 pg_get_object_address('database', '{one}', '{}');
251 pg_get_object_address('server', '{one}', '{}');
257 pg_get_object_address('extension', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/ |
| H A D | object_address.sql | 49 SELECT pg_get_object_address('stone', '{}', '{}');
50 SELECT pg_get_object_address('table', '{}', '{}');
51 SELECT pg_get_object_address('table', '{NULL}', '{}');
62 PERFORM pg_get_object_address(objtype, '{one}', '{}');
111 SELECT pg_get_object_address('language', '{one}', '{}');
116 SELECT pg_get_object_address('schema', '{one}', '{}');
118 SELECT pg_get_object_address('role', '{one}', '{}');
119 SELECT pg_get_object_address('role', '{one,two}', '{}');
120 SELECT pg_get_object_address('database', '{one}', '{}');
126 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/ |
| H A D | object_address.sql | 49 SELECT pg_get_object_address('stone', '{}', '{}');
50 SELECT pg_get_object_address('table', '{}', '{}');
51 SELECT pg_get_object_address('table', '{NULL}', '{}');
62 PERFORM pg_get_object_address(objtype, '{one}', '{}');
111 SELECT pg_get_object_address('language', '{one}', '{}');
116 SELECT pg_get_object_address('schema', '{one}', '{}');
118 SELECT pg_get_object_address('role', '{one}', '{}');
119 SELECT pg_get_object_address('role', '{one,two}', '{}');
120 SELECT pg_get_object_address('database', '{one}', '{}');
126 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/ |
| H A D | object_address.sql | 49 SELECT pg_get_object_address('stone', '{}', '{}');
50 SELECT pg_get_object_address('table', '{}', '{}');
51 SELECT pg_get_object_address('table', '{NULL}', '{}');
62 PERFORM pg_get_object_address(objtype, '{one}', '{}');
111 SELECT pg_get_object_address('language', '{one}', '{}');
116 SELECT pg_get_object_address('schema', '{one}', '{}');
118 SELECT pg_get_object_address('role', '{one}', '{}');
119 SELECT pg_get_object_address('role', '{one,two}', '{}');
120 SELECT pg_get_object_address('database', '{one}', '{}');
126 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/ |
| H A D | object_address.sql | 49 SELECT pg_get_object_address('stone', '{}', '{}');
50 SELECT pg_get_object_address('table', '{}', '{}');
51 SELECT pg_get_object_address('table', '{NULL}', '{}');
62 PERFORM pg_get_object_address(objtype, '{one}', '{}');
111 SELECT pg_get_object_address('language', '{one}', '{}');
116 SELECT pg_get_object_address('schema', '{one}', '{}');
118 SELECT pg_get_object_address('role', '{one}', '{}');
119 SELECT pg_get_object_address('role', '{one,two}', '{}');
120 SELECT pg_get_object_address('database', '{one}', '{}');
126 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/ |
| H A D | object_address.sql | 49 SELECT pg_get_object_address('stone', '{}', '{}');
50 SELECT pg_get_object_address('table', '{}', '{}');
51 SELECT pg_get_object_address('table', '{NULL}', '{}');
62 PERFORM pg_get_object_address(objtype, '{one}', '{}');
111 SELECT pg_get_object_address('language', '{one}', '{}');
116 SELECT pg_get_object_address('schema', '{one}', '{}');
118 SELECT pg_get_object_address('role', '{one}', '{}');
119 SELECT pg_get_object_address('role', '{one,two}', '{}');
120 SELECT pg_get_object_address('database', '{one}', '{}');
126 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/ |
| H A D | object_address.sql | 53 SELECT pg_get_object_address('stone', '{}', '{}');
54 SELECT pg_get_object_address('table', '{}', '{}');
55 SELECT pg_get_object_address('table', '{NULL}', '{}');
66 PERFORM pg_get_object_address(objtype, '{one}', '{}');
115 SELECT pg_get_object_address('language', '{one}', '{}');
120 SELECT pg_get_object_address('schema', '{one}', '{}');
122 SELECT pg_get_object_address('role', '{one}', '{}');
123 SELECT pg_get_object_address('role', '{one,two}', '{}');
124 SELECT pg_get_object_address('database', '{one}', '{}');
130 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/ |
| H A D | object_address.sql | 53 SELECT pg_get_object_address('stone', '{}', '{}');
54 SELECT pg_get_object_address('table', '{}', '{}');
55 SELECT pg_get_object_address('table', '{NULL}', '{}');
66 PERFORM pg_get_object_address(objtype, '{one}', '{}');
115 SELECT pg_get_object_address('language', '{one}', '{}');
120 SELECT pg_get_object_address('schema', '{one}', '{}');
122 SELECT pg_get_object_address('role', '{one}', '{}');
123 SELECT pg_get_object_address('role', '{one,two}', '{}');
124 SELECT pg_get_object_address('database', '{one}', '{}');
130 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/ |
| H A D | object_address.sql | 53 SELECT pg_get_object_address('stone', '{}', '{}');
54 SELECT pg_get_object_address('table', '{}', '{}');
55 SELECT pg_get_object_address('table', '{NULL}', '{}');
66 PERFORM pg_get_object_address(objtype, '{one}', '{}');
115 SELECT pg_get_object_address('language', '{one}', '{}');
120 SELECT pg_get_object_address('schema', '{one}', '{}');
122 SELECT pg_get_object_address('role', '{one}', '{}');
123 SELECT pg_get_object_address('role', '{one,two}', '{}');
124 SELECT pg_get_object_address('database', '{one}', '{}');
130 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/ |
| H A D | object_address.sql | 53 SELECT pg_get_object_address('stone', '{}', '{}');
54 SELECT pg_get_object_address('table', '{}', '{}');
55 SELECT pg_get_object_address('table', '{NULL}', '{}');
66 PERFORM pg_get_object_address(objtype, '{one}', '{}');
115 SELECT pg_get_object_address('language', '{one}', '{}');
120 SELECT pg_get_object_address('schema', '{one}', '{}');
122 SELECT pg_get_object_address('role', '{one}', '{}');
123 SELECT pg_get_object_address('role', '{one,two}', '{}');
124 SELECT pg_get_object_address('database', '{one}', '{}');
130 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/ |
| H A D | object_address.sql | 49 SELECT pg_get_object_address('stone', '{}', '{}');
50 SELECT pg_get_object_address('table', '{}', '{}');
51 SELECT pg_get_object_address('table', '{NULL}', '{}');
62 PERFORM pg_get_object_address(objtype, '{one}', '{}');
111 SELECT pg_get_object_address('language', '{one}', '{}');
116 SELECT pg_get_object_address('schema', '{one}', '{}');
118 SELECT pg_get_object_address('role', '{one}', '{}');
119 SELECT pg_get_object_address('role', '{one,two}', '{}');
120 SELECT pg_get_object_address('database', '{one}', '{}');
126 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/ |
| H A D | object_address.sql | 49 SELECT pg_get_object_address('stone', '{}', '{}');
50 SELECT pg_get_object_address('table', '{}', '{}');
51 SELECT pg_get_object_address('table', '{NULL}', '{}');
62 PERFORM pg_get_object_address(objtype, '{one}', '{}');
111 SELECT pg_get_object_address('language', '{one}', '{}');
116 SELECT pg_get_object_address('schema', '{one}', '{}');
118 SELECT pg_get_object_address('role', '{one}', '{}');
119 SELECT pg_get_object_address('role', '{one,two}', '{}');
120 SELECT pg_get_object_address('database', '{one}', '{}');
126 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/ |
| H A D | object_address.sql | 53 SELECT pg_get_object_address('stone', '{}', '{}');
54 SELECT pg_get_object_address('table', '{}', '{}');
55 SELECT pg_get_object_address('table', '{NULL}', '{}');
66 PERFORM pg_get_object_address(objtype, '{one}', '{}');
115 SELECT pg_get_object_address('language', '{one}', '{}');
120 SELECT pg_get_object_address('schema', '{one}', '{}');
122 SELECT pg_get_object_address('role', '{one}', '{}');
123 SELECT pg_get_object_address('role', '{one,two}', '{}');
124 SELECT pg_get_object_address('database', '{one}', '{}');
130 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/ |
| H A D | object_address.sql | 53 SELECT pg_get_object_address('stone', '{}', '{}');
54 SELECT pg_get_object_address('table', '{}', '{}');
55 SELECT pg_get_object_address('table', '{NULL}', '{}');
66 PERFORM pg_get_object_address(objtype, '{one}', '{}');
115 SELECT pg_get_object_address('language', '{one}', '{}');
120 SELECT pg_get_object_address('schema', '{one}', '{}');
122 SELECT pg_get_object_address('role', '{one}', '{}');
123 SELECT pg_get_object_address('role', '{one,two}', '{}');
124 SELECT pg_get_object_address('database', '{one}', '{}');
130 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/sql/ |
| H A D | object_address.sql | 53 SELECT pg_get_object_address('stone', '{}', '{}');
54 SELECT pg_get_object_address('table', '{}', '{}');
55 SELECT pg_get_object_address('table', '{NULL}', '{}');
66 PERFORM pg_get_object_address(objtype, '{one}', '{}');
115 SELECT pg_get_object_address('language', '{one}', '{}');
120 SELECT pg_get_object_address('schema', '{one}', '{}');
122 SELECT pg_get_object_address('role', '{one}', '{}');
123 SELECT pg_get_object_address('role', '{one,two}', '{}');
124 SELECT pg_get_object_address('database', '{one}', '{}');
130 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/ |
| H A D | object_address.sql | 53 SELECT pg_get_object_address('stone', '{}', '{}');
54 SELECT pg_get_object_address('table', '{}', '{}');
55 SELECT pg_get_object_address('table', '{NULL}', '{}');
66 PERFORM pg_get_object_address(objtype, '{one}', '{}');
115 SELECT pg_get_object_address('language', '{one}', '{}');
120 SELECT pg_get_object_address('schema', '{one}', '{}');
122 SELECT pg_get_object_address('role', '{one}', '{}');
123 SELECT pg_get_object_address('role', '{one,two}', '{}');
124 SELECT pg_get_object_address('database', '{one}', '{}');
130 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql13-plpython/postgresql-13.5/src/test/regress/sql/ |
| H A D | object_address.sql | 56 SELECT pg_get_object_address('stone', '{}', '{}');
57 SELECT pg_get_object_address('table', '{}', '{}');
58 SELECT pg_get_object_address('table', '{NULL}', '{}');
69 PERFORM pg_get_object_address(objtype, '{one}', '{}');
118 SELECT pg_get_object_address('language', '{one}', '{}');
123 SELECT pg_get_object_address('schema', '{one}', '{}');
125 SELECT pg_get_object_address('role', '{one}', '{}');
126 SELECT pg_get_object_address('role', '{one,two}', '{}');
127 SELECT pg_get_object_address('database', '{one}', '{}');
133 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql13-pltcl/postgresql-13.5/src/test/regress/sql/ |
| H A D | object_address.sql | 56 SELECT pg_get_object_address('stone', '{}', '{}');
57 SELECT pg_get_object_address('table', '{}', '{}');
58 SELECT pg_get_object_address('table', '{NULL}', '{}');
69 PERFORM pg_get_object_address(objtype, '{one}', '{}');
118 SELECT pg_get_object_address('language', '{one}', '{}');
123 SELECT pg_get_object_address('schema', '{one}', '{}');
125 SELECT pg_get_object_address('role', '{one}', '{}');
126 SELECT pg_get_object_address('role', '{one,two}', '{}');
127 SELECT pg_get_object_address('database', '{one}', '{}');
133 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql13-server/postgresql-13.5/src/test/regress/sql/ |
| H A D | object_address.sql | 56 SELECT pg_get_object_address('stone', '{}', '{}');
57 SELECT pg_get_object_address('table', '{}', '{}');
58 SELECT pg_get_object_address('table', '{NULL}', '{}');
69 PERFORM pg_get_object_address(objtype, '{one}', '{}');
118 SELECT pg_get_object_address('language', '{one}', '{}');
123 SELECT pg_get_object_address('schema', '{one}', '{}');
125 SELECT pg_get_object_address('role', '{one}', '{}');
126 SELECT pg_get_object_address('role', '{one,two}', '{}');
127 SELECT pg_get_object_address('database', '{one}', '{}');
133 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql13-contrib/postgresql-13.5/src/test/regress/sql/ |
| H A D | object_address.sql | 56 SELECT pg_get_object_address('stone', '{}', '{}');
57 SELECT pg_get_object_address('table', '{}', '{}');
58 SELECT pg_get_object_address('table', '{NULL}', '{}');
69 PERFORM pg_get_object_address(objtype, '{one}', '{}');
118 SELECT pg_get_object_address('language', '{one}', '{}');
123 SELECT pg_get_object_address('schema', '{one}', '{}');
125 SELECT pg_get_object_address('role', '{one}', '{}');
126 SELECT pg_get_object_address('role', '{one,two}', '{}');
127 SELECT pg_get_object_address('database', '{one}', '{}');
133 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql12-docs/postgresql-12.9/src/test/regress/sql/ |
| H A D | object_address.sql | 53 SELECT pg_get_object_address('stone', '{}', '{}');
54 SELECT pg_get_object_address('table', '{}', '{}');
55 SELECT pg_get_object_address('table', '{NULL}', '{}');
66 PERFORM pg_get_object_address(objtype, '{one}', '{}');
115 SELECT pg_get_object_address('language', '{one}', '{}');
120 SELECT pg_get_object_address('schema', '{one}', '{}');
122 SELECT pg_get_object_address('role', '{one}', '{}');
123 SELECT pg_get_object_address('role', '{one,two}', '{}');
124 SELECT pg_get_object_address('database', '{one}', '{}');
130 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql13-client/postgresql-13.5/src/test/regress/sql/ |
| H A D | object_address.sql | 56 SELECT pg_get_object_address('stone', '{}', '{}');
57 SELECT pg_get_object_address('table', '{}', '{}');
58 SELECT pg_get_object_address('table', '{NULL}', '{}');
69 PERFORM pg_get_object_address(objtype, '{one}', '{}');
118 SELECT pg_get_object_address('language', '{one}', '{}');
123 SELECT pg_get_object_address('schema', '{one}', '{}');
125 SELECT pg_get_object_address('role', '{one}', '{}');
126 SELECT pg_get_object_address('role', '{one,two}', '{}');
127 SELECT pg_get_object_address('database', '{one}', '{}');
133 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql12-server/postgresql-12.9/src/test/regress/sql/ |
| H A D | object_address.sql | 53 SELECT pg_get_object_address('stone', '{}', '{}');
54 SELECT pg_get_object_address('table', '{}', '{}');
55 SELECT pg_get_object_address('table', '{NULL}', '{}');
66 PERFORM pg_get_object_address(objtype, '{one}', '{}');
115 SELECT pg_get_object_address('language', '{one}', '{}');
120 SELECT pg_get_object_address('schema', '{one}', '{}');
122 SELECT pg_get_object_address('role', '{one}', '{}');
123 SELECT pg_get_object_address('role', '{one,two}', '{}');
124 SELECT pg_get_object_address('database', '{one}', '{}');
130 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|
| /dports/databases/postgresql12-plpython/postgresql-12.9/src/test/regress/sql/ |
| H A D | object_address.sql | 53 SELECT pg_get_object_address('stone', '{}', '{}');
54 SELECT pg_get_object_address('table', '{}', '{}');
55 SELECT pg_get_object_address('table', '{NULL}', '{}');
66 PERFORM pg_get_object_address(objtype, '{one}', '{}');
115 SELECT pg_get_object_address('language', '{one}', '{}');
120 SELECT pg_get_object_address('schema', '{one}', '{}');
122 SELECT pg_get_object_address('role', '{one}', '{}');
123 SELECT pg_get_object_address('role', '{one,two}', '{}');
124 SELECT pg_get_object_address('database', '{one}', '{}');
130 SELECT pg_get_object_address('server', '{one}', '{}');
[all …]
|