Home
last modified time | relevance | path

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

1234

/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/
H A Drules.sql1126 rtest_view2 Y
1150 rtest_view2 Y
1161 rtest_view2 Y
1205 INSERT INTO rtest_view2
1208 INSERT INTO rtest_view2
1211 INSERT INTO rtest_view2
1214 INSERT INTO rtest_view2
1217 INSERT INTO rtest_view2
1220 INSERT INTO rtest_view2
1223 INSERT INTO rtest_view2
[all …]
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4);
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4);
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/
H A Drules.sql420 create table rtest_view2 (a int4); table
424 where 0 < (select count(*) from rtest_view2 Y where Y.a = X.a);
429 from rtest_view1 X, rtest_view2 Y
447 insert into rtest_view2 values (2);
448 insert into rtest_view2 values (2);
449 insert into rtest_view2 values (4);
450 insert into rtest_view2 values (5);
451 insert into rtest_view2 values (7);
452 insert into rtest_view2 values (7);
453 insert into rtest_view2 values (7);
[all …]

1234