Home
last modified time | relevance | path

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

1234

/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/
H A Drules.sql1104 CREATE TABLE rtest_view3 ( table
1257 INSERT INTO rtest_view3
1268 rtest_view3;
1270 DELETE FROM rtest_view3;
1272 INSERT INTO rtest_view3
1284 rtest_view3;
1286 DELETE FROM rtest_view3;
1288 INSERT INTO rtest_view3
1297 rtest_view3;
1299 DELETE FROM rtest_view3;
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text);
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text);
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/
H A Drules.sql421 create table rtest_view3 (a int4, b text); table
462 insert into rtest_view3 select * from rtest_vview1 where a < 7;
463 select * from rtest_view3;
464 delete from rtest_view3;
466 insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';
467 select * from rtest_view3;
468 delete from rtest_view3;
470 insert into rtest_view3 select * from rtest_vview3;
471 select * from rtest_view3;
472 delete from rtest_view3;

1234