/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/ |
H A D | create_table.sql | 264 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 D | create_table.sql | 264 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 D | create_table.sql | 264 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 D | create_table.sql | 264 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 D | create_table.sql | 264 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 D | create_table.sql | 264 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 D | create_table.sql | 264 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 D | create_table.out | 247 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 D | create_table.out | 247 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 D | create_table.out | 247 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 D | create_table.out | 247 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 D | create_table.out | 247 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 D | create_table.out | 247 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 D | create_table.out | 247 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 D | create_table.sql | 272 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 D | create_table.sql | 272 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 D | create_table.sql | 272 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 D | create_table.sql | 272 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 D | create_table.sql | 272 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 D | create_table.sql | 272 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 D | create_table.sql | 272 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 D | create_table.sql | 275 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 D | create_table.sql | 361 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 D | create_table.sql | 276 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 D | create_table.sql | 276 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;
|