Home
last modified time | relevance | path

Searched refs:as_select1 (Results 1 – 25 of 86) sorted by relevance

1234

/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/
H A Dcreate_table.sql264 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
265 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
266 CREATE TABLE IF NOT EXISTS as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
267 DROP TABLE as_select1;
270 CREATE TABLE as_select1 AS EXECUTE select1; table
271 CREATE TABLE as_select1 AS EXECUTE select1; table
272 SELECT * FROM as_select1;
273 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1; table
274 DROP TABLE as_select1;
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/
H A Dcreate_table.sql264 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
265 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
266 CREATE TABLE IF NOT EXISTS as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
267 DROP TABLE as_select1;
270 CREATE TABLE as_select1 AS EXECUTE select1; table
271 CREATE TABLE as_select1 AS EXECUTE select1; table
272 SELECT * FROM as_select1;
273 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1; table
274 DROP TABLE as_select1;
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/
H A Dcreate_table.sql264 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
265 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
266 CREATE TABLE IF NOT EXISTS as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
267 DROP TABLE as_select1;
270 CREATE TABLE as_select1 AS EXECUTE select1; table
271 CREATE TABLE as_select1 AS EXECUTE select1; table
272 SELECT * FROM as_select1;
273 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1; table
274 DROP TABLE as_select1;
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/
H A Dcreate_table.sql264 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
265 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
266 CREATE TABLE IF NOT EXISTS as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
267 DROP TABLE as_select1;
270 CREATE TABLE as_select1 AS EXECUTE select1; table
271 CREATE TABLE as_select1 AS EXECUTE select1; table
272 SELECT * FROM as_select1;
273 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1; table
274 DROP TABLE as_select1;
/dports/databases/postgresql96-docs/postgresql-9.6.24/src/test/regress/sql/
H A Dcreate_table.sql264 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
265 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
266 CREATE TABLE IF NOT EXISTS as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
267 DROP TABLE as_select1;
270 CREATE TABLE as_select1 AS EXECUTE select1; table
271 CREATE TABLE as_select1 AS EXECUTE select1; table
272 SELECT * FROM as_select1;
273 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1; table
274 DROP TABLE as_select1;
/dports/databases/postgresql96-contrib/postgresql-9.6.24/src/test/regress/sql/
H A Dcreate_table.sql264 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
265 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
266 CREATE TABLE IF NOT EXISTS as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
267 DROP TABLE as_select1;
270 CREATE TABLE as_select1 AS EXECUTE select1; table
271 CREATE TABLE as_select1 AS EXECUTE select1; table
272 SELECT * FROM as_select1;
273 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1; table
274 DROP TABLE as_select1;
/dports/databases/postgresql96-client/postgresql-9.6.24/src/test/regress/sql/
H A Dcreate_table.sql264 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
265 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
266 CREATE TABLE IF NOT EXISTS as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
267 DROP TABLE as_select1;
270 CREATE TABLE as_select1 AS EXECUTE select1; table
271 CREATE TABLE as_select1 AS EXECUTE select1; table
272 SELECT * FROM as_select1;
273 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1; table
274 DROP TABLE as_select1;
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/expected/
H A Dcreate_table.out247 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r';
249 ERROR: relation "as_select1" already exists
251 NOTICE: relation "as_select1" already exists, skipping
252 DROP TABLE as_select1;
254 CREATE TABLE as_select1 AS EXECUTE select1;
255 CREATE TABLE as_select1 AS EXECUTE select1;
256 ERROR: relation "as_select1" already exists
257 SELECT * FROM as_select1;
263 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1;
264 NOTICE: relation "as_select1" already exists, skipping
[all …]
/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/expected/
H A Dcreate_table.out247 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r';
249 ERROR: relation "as_select1" already exists
251 NOTICE: relation "as_select1" already exists, skipping
252 DROP TABLE as_select1;
254 CREATE TABLE as_select1 AS EXECUTE select1;
255 CREATE TABLE as_select1 AS EXECUTE select1;
256 ERROR: relation "as_select1" already exists
257 SELECT * FROM as_select1;
263 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1;
264 NOTICE: relation "as_select1" already exists, skipping
[all …]
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/expected/
H A Dcreate_table.out247 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r';
249 ERROR: relation "as_select1" already exists
251 NOTICE: relation "as_select1" already exists, skipping
252 DROP TABLE as_select1;
254 CREATE TABLE as_select1 AS EXECUTE select1;
255 CREATE TABLE as_select1 AS EXECUTE select1;
256 ERROR: relation "as_select1" already exists
257 SELECT * FROM as_select1;
263 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1;
264 NOTICE: relation "as_select1" already exists, skipping
[all …]
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/expected/
H A Dcreate_table.out247 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r';
249 ERROR: relation "as_select1" already exists
251 NOTICE: relation "as_select1" already exists, skipping
252 DROP TABLE as_select1;
254 CREATE TABLE as_select1 AS EXECUTE select1;
255 CREATE TABLE as_select1 AS EXECUTE select1;
256 ERROR: relation "as_select1" already exists
257 SELECT * FROM as_select1;
263 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1;
264 NOTICE: relation "as_select1" already exists, skipping
[all …]
/dports/databases/postgresql96-docs/postgresql-9.6.24/src/test/regress/expected/
H A Dcreate_table.out247 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r';
249 ERROR: relation "as_select1" already exists
251 NOTICE: relation "as_select1" already exists, skipping
252 DROP TABLE as_select1;
254 CREATE TABLE as_select1 AS EXECUTE select1;
255 CREATE TABLE as_select1 AS EXECUTE select1;
256 ERROR: relation "as_select1" already exists
257 SELECT * FROM as_select1;
263 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1;
264 NOTICE: relation "as_select1" already exists, skipping
[all …]
/dports/databases/postgresql96-client/postgresql-9.6.24/src/test/regress/expected/
H A Dcreate_table.out247 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r';
249 ERROR: relation "as_select1" already exists
251 NOTICE: relation "as_select1" already exists, skipping
252 DROP TABLE as_select1;
254 CREATE TABLE as_select1 AS EXECUTE select1;
255 CREATE TABLE as_select1 AS EXECUTE select1;
256 ERROR: relation "as_select1" already exists
257 SELECT * FROM as_select1;
263 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1;
264 NOTICE: relation "as_select1" already exists, skipping
[all …]
/dports/databases/postgresql96-contrib/postgresql-9.6.24/src/test/regress/expected/
H A Dcreate_table.out247 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r';
249 ERROR: relation "as_select1" already exists
251 NOTICE: relation "as_select1" already exists, skipping
252 DROP TABLE as_select1;
254 CREATE TABLE as_select1 AS EXECUTE select1;
255 CREATE TABLE as_select1 AS EXECUTE select1;
256 ERROR: relation "as_select1" already exists
257 SELECT * FROM as_select1;
263 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1;
264 NOTICE: relation "as_select1" already exists, skipping
[all …]
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/
H A Dcreate_table.sql272 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
273 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
274 CREATE TABLE IF NOT EXISTS as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
275 DROP TABLE as_select1;
278 CREATE TABLE as_select1 AS EXECUTE select1; table
279 CREATE TABLE as_select1 AS EXECUTE select1; table
280 SELECT * FROM as_select1;
281 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1; table
282 DROP TABLE as_select1;
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/
H A Dcreate_table.sql272 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
273 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
274 CREATE TABLE IF NOT EXISTS as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
275 DROP TABLE as_select1;
278 CREATE TABLE as_select1 AS EXECUTE select1; table
279 CREATE TABLE as_select1 AS EXECUTE select1; table
280 SELECT * FROM as_select1;
281 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1; table
282 DROP TABLE as_select1;
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/
H A Dcreate_table.sql272 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
273 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
274 CREATE TABLE IF NOT EXISTS as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
275 DROP TABLE as_select1;
278 CREATE TABLE as_select1 AS EXECUTE select1; table
279 CREATE TABLE as_select1 AS EXECUTE select1; table
280 SELECT * FROM as_select1;
281 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1; table
282 DROP TABLE as_select1;
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/
H A Dcreate_table.sql272 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
273 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
274 CREATE TABLE IF NOT EXISTS as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
275 DROP TABLE as_select1;
278 CREATE TABLE as_select1 AS EXECUTE select1; table
279 CREATE TABLE as_select1 AS EXECUTE select1; table
280 SELECT * FROM as_select1;
281 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1; table
282 DROP TABLE as_select1;
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/
H A Dcreate_table.sql272 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
273 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
274 CREATE TABLE IF NOT EXISTS as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
275 DROP TABLE as_select1;
278 CREATE TABLE as_select1 AS EXECUTE select1; table
279 CREATE TABLE as_select1 AS EXECUTE select1; table
280 SELECT * FROM as_select1;
281 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1; table
282 DROP TABLE as_select1;
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/
H A Dcreate_table.sql272 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
273 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
274 CREATE TABLE IF NOT EXISTS as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
275 DROP TABLE as_select1;
278 CREATE TABLE as_select1 AS EXECUTE select1; table
279 CREATE TABLE as_select1 AS EXECUTE select1; table
280 SELECT * FROM as_select1;
281 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1; table
282 DROP TABLE as_select1;
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/
H A Dcreate_table.sql272 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
273 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
274 CREATE TABLE IF NOT EXISTS as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
275 DROP TABLE as_select1;
278 CREATE TABLE as_select1 AS EXECUTE select1; table
279 CREATE TABLE as_select1 AS EXECUTE select1; table
280 SELECT * FROM as_select1;
281 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1; table
282 DROP TABLE as_select1;
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/
H A Dcreate_table.sql275 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
276 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
277 CREATE TABLE IF NOT EXISTS as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
278 DROP TABLE as_select1;
281 CREATE TABLE as_select1 AS EXECUTE select1; table
282 CREATE TABLE as_select1 AS EXECUTE select1; table
283 SELECT * FROM as_select1;
284 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1; table
285 DROP TABLE as_select1;
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/
H A Dcreate_table.sql361 CREATE TABLE as_select1 AS table
369 CREATE TABLE as_select1 AS table
377 CREATE TABLE IF NOT EXISTS as_select1 AS table
385 DROP TABLE as_select1;
391 CREATE TABLE as_select1 AS table
394 CREATE TABLE as_select1 AS table
400 as_select1;
402 CREATE TABLE IF NOT EXISTS as_select1 AS table
405 DROP TABLE as_select1;
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/
H A Dcreate_table.sql276 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r';
277 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r';
278 CREATE TABLE IF NOT EXISTS as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r';
279 DROP TABLE as_select1;
282 CREATE TABLE as_select1 AS EXECUTE select1;
283 CREATE TABLE as_select1 AS EXECUTE select1;
284 SELECT * FROM as_select1;
285 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1;
286 DROP TABLE as_select1;
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/
H A Dcreate_table.sql276 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
277 CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
278 CREATE TABLE IF NOT EXISTS as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; table
279 DROP TABLE as_select1;
282 CREATE TABLE as_select1 AS EXECUTE select1; table
283 CREATE TABLE as_select1 AS EXECUTE select1; table
284 SELECT * FROM as_select1;
285 CREATE TABLE IF NOT EXISTS as_select1 AS EXECUTE select1; table
286 DROP TABLE as_select1;

1234