Home
last modified time | relevance | path

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

1234

/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/
H A Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql9 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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 Drules.sql10 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;

1234