/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
H A D | rules.sql | 9 CREATE TABLE rtest_t1 ( table 28 rtest_t1; 32 INSERT INTO rtest_t1 VALUES (NEW.a, NEW.b); 38 rtest_t1 SET 45 DELETE FROM rtest_t1 356 DELETE FROM rtest_t1 417 rtest_t1 512 rtest_t1
|
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/ |
H A D | rules.sql | 10 create table rtest_t1 (a int4, b int4); table 14 create view rtest_v1 as select * from rtest_t1; 16 insert into rtest_t1 values (new.a, new.b); 18 update rtest_t1 set a = new.a, b = new.b 21 delete from rtest_t1 where a = old.a; 186 ** DO INSTEAD DELETE FROM rtest_t1 WHERE a = old.a 209 update rtest_t1 set a = a + 10 where b isnull; 231 update rtest_t1 set a = a + 10 where b > 30;
|