Home
last modified time | relevance | path

Searched refs:rules_base (Results 1 – 25 of 115) sorted by relevance

12345

/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/
H A Drules.sql985 create table rules_base(f1 int, f2 int); table
986 insert into rules_base values(1,2), (11,12);
987 create rule r1 as on update to rules_base do instead
988 select * from rules_base where f1 = 1 for update;
989 update rules_base set f2 = f2 + 1;
990 create or replace rule r1 as on update to rules_base do instead
991 select * from rules_base where f1 = 11 for update of rules_base;
992 update rules_base set f2 = f2 + 1;
993 create or replace rule r1 as on update to rules_base do instead
994 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/
H A Drules.sql985 create table rules_base(f1 int, f2 int); table
986 insert into rules_base values(1,2), (11,12);
987 create rule r1 as on update to rules_base do instead
988 select * from rules_base where f1 = 1 for update;
989 update rules_base set f2 = f2 + 1;
990 create or replace rule r1 as on update to rules_base do instead
991 select * from rules_base where f1 = 11 for update of rules_base;
992 update rules_base set f2 = f2 + 1;
993 create or replace rule r1 as on update to rules_base do instead
994 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/
H A Drules.sql985 create table rules_base(f1 int, f2 int); table
986 insert into rules_base values(1,2), (11,12);
987 create rule r1 as on update to rules_base do instead
988 select * from rules_base where f1 = 1 for update;
989 update rules_base set f2 = f2 + 1;
990 create or replace rule r1 as on update to rules_base do instead
991 select * from rules_base where f1 = 11 for update of rules_base;
992 update rules_base set f2 = f2 + 1;
993 create or replace rule r1 as on update to rules_base do instead
994 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/
H A Drules.sql985 create table rules_base(f1 int, f2 int); table
986 insert into rules_base values(1,2), (11,12);
987 create rule r1 as on update to rules_base do instead
988 select * from rules_base where f1 = 1 for update;
989 update rules_base set f2 = f2 + 1;
990 create or replace rule r1 as on update to rules_base do instead
991 select * from rules_base where f1 = 11 for update of rules_base;
992 update rules_base set f2 = f2 + 1;
993 create or replace rule r1 as on update to rules_base do instead
994 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/
H A Drules.sql996 create table rules_base(f1 int, f2 int); table
997 insert into rules_base values(1,2), (11,12);
998 create rule r1 as on update to rules_base do instead
999 select * from rules_base where f1 = 1 for update;
1000 update rules_base set f2 = f2 + 1;
1001 create or replace rule r1 as on update to rules_base do instead
1002 select * from rules_base where f1 = 11 for update of rules_base;
1003 update rules_base set f2 = f2 + 1;
1004 create or replace rule r1 as on update to rules_base do instead
1005 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/
H A Drules.sql996 create table rules_base(f1 int, f2 int); table
997 insert into rules_base values(1,2), (11,12);
998 create rule r1 as on update to rules_base do instead
999 select * from rules_base where f1 = 1 for update;
1000 update rules_base set f2 = f2 + 1;
1001 create or replace rule r1 as on update to rules_base do instead
1002 select * from rules_base where f1 = 11 for update of rules_base;
1003 update rules_base set f2 = f2 + 1;
1004 create or replace rule r1 as on update to rules_base do instead
1005 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/
H A Drules.sql996 create table rules_base(f1 int, f2 int); table
997 insert into rules_base values(1,2), (11,12);
998 create rule r1 as on update to rules_base do instead
999 select * from rules_base where f1 = 1 for update;
1000 update rules_base set f2 = f2 + 1;
1001 create or replace rule r1 as on update to rules_base do instead
1002 select * from rules_base where f1 = 11 for update of rules_base;
1003 update rules_base set f2 = f2 + 1;
1004 create or replace rule r1 as on update to rules_base do instead
1005 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/
H A Drules.sql996 create table rules_base(f1 int, f2 int); table
997 insert into rules_base values(1,2), (11,12);
998 create rule r1 as on update to rules_base do instead
999 select * from rules_base where f1 = 1 for update;
1000 update rules_base set f2 = f2 + 1;
1001 create or replace rule r1 as on update to rules_base do instead
1002 select * from rules_base where f1 = 11 for update of rules_base;
1003 update rules_base set f2 = f2 + 1;
1004 create or replace rule r1 as on update to rules_base do instead
1005 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/
H A Drules.sql996 create table rules_base(f1 int, f2 int); table
997 insert into rules_base values(1,2), (11,12);
998 create rule r1 as on update to rules_base do instead
999 select * from rules_base where f1 = 1 for update;
1000 update rules_base set f2 = f2 + 1;
1001 create or replace rule r1 as on update to rules_base do instead
1002 select * from rules_base where f1 = 11 for update of rules_base;
1003 update rules_base set f2 = f2 + 1;
1004 create or replace rule r1 as on update to rules_base do instead
1005 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/
H A Drules.sql996 create table rules_base(f1 int, f2 int);
997 insert into rules_base values(1,2), (11,12);
998 create rule r1 as on update to rules_base do instead
999 select * from rules_base where f1 = 1 for update;
1000 update rules_base set f2 = f2 + 1;
1001 create or replace rule r1 as on update to rules_base do instead
1002 select * from rules_base where f1 = 11 for update of rules_base;
1003 update rules_base set f2 = f2 + 1;
1004 create or replace rule r1 as on update to rules_base do instead
1005 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/
H A Drules.sql996 create table rules_base(f1 int, f2 int); table
997 insert into rules_base values(1,2), (11,12);
998 create rule r1 as on update to rules_base do instead
999 select * from rules_base where f1 = 1 for update;
1000 update rules_base set f2 = f2 + 1;
1001 create or replace rule r1 as on update to rules_base do instead
1002 select * from rules_base where f1 = 11 for update of rules_base;
1003 update rules_base set f2 = f2 + 1;
1004 create or replace rule r1 as on update to rules_base do instead
1005 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/
H A Drules.sql996 create table rules_base(f1 int, f2 int); table
997 insert into rules_base values(1,2), (11,12);
998 create rule r1 as on update to rules_base do instead
999 select * from rules_base where f1 = 1 for update;
1000 update rules_base set f2 = f2 + 1;
1001 create or replace rule r1 as on update to rules_base do instead
1002 select * from rules_base where f1 = 11 for update of rules_base;
1003 update rules_base set f2 = f2 + 1;
1004 create or replace rule r1 as on update to rules_base do instead
1005 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/
H A Drules.sql996 create table rules_base(f1 int, f2 int); table
997 insert into rules_base values(1,2), (11,12);
998 create rule r1 as on update to rules_base do instead
999 select * from rules_base where f1 = 1 for update;
1000 update rules_base set f2 = f2 + 1;
1001 create or replace rule r1 as on update to rules_base do instead
1002 select * from rules_base where f1 = 11 for update of rules_base;
1003 update rules_base set f2 = f2 + 1;
1004 create or replace rule r1 as on update to rules_base do instead
1005 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/
H A Drules.sql996 create table rules_base(f1 int, f2 int); table
997 insert into rules_base values(1,2), (11,12);
998 create rule r1 as on update to rules_base do instead
999 select * from rules_base where f1 = 1 for update;
1000 update rules_base set f2 = f2 + 1;
1001 create or replace rule r1 as on update to rules_base do instead
1002 select * from rules_base where f1 = 11 for update of rules_base;
1003 update rules_base set f2 = f2 + 1;
1004 create or replace rule r1 as on update to rules_base do instead
1005 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/
H A Drules.sql996 create table rules_base(f1 int, f2 int); table
997 insert into rules_base values(1,2), (11,12);
998 create rule r1 as on update to rules_base do instead
999 select * from rules_base where f1 = 1 for update;
1000 update rules_base set f2 = f2 + 1;
1001 create or replace rule r1 as on update to rules_base do instead
1002 select * from rules_base where f1 = 11 for update of rules_base;
1003 update rules_base set f2 = f2 + 1;
1004 create or replace rule r1 as on update to rules_base do instead
1005 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/
H A Drules.sql997 create table rules_base(f1 int, f2 int); table
998 insert into rules_base values(1,2), (11,12);
999 create rule r1 as on update to rules_base do instead
1000 select * from rules_base where f1 = 1 for update;
1001 update rules_base set f2 = f2 + 1;
1002 create or replace rule r1 as on update to rules_base do instead
1003 select * from rules_base where f1 = 11 for update of rules_base;
1004 update rules_base set f2 = f2 + 1;
1005 create or replace rule r1 as on update to rules_base do instead
1006 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/
H A Drules.sql996 create table rules_base(f1 int, f2 int); table
997 insert into rules_base values(1,2), (11,12);
998 create rule r1 as on update to rules_base do instead
999 select * from rules_base where f1 = 1 for update;
1000 update rules_base set f2 = f2 + 1;
1001 create or replace rule r1 as on update to rules_base do instead
1002 select * from rules_base where f1 = 11 for update of rules_base;
1003 update rules_base set f2 = f2 + 1;
1004 create or replace rule r1 as on update to rules_base do instead
1005 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/
H A Drules.sql996 create table rules_base(f1 int, f2 int);
997 insert into rules_base values(1,2), (11,12);
998 create rule r1 as on update to rules_base do instead
999 select * from rules_base where f1 = 1 for update;
1000 update rules_base set f2 = f2 + 1;
1001 create or replace rule r1 as on update to rules_base do instead
1002 select * from rules_base where f1 = 11 for update of rules_base;
1003 update rules_base set f2 = f2 + 1;
1004 create or replace rule r1 as on update to rules_base do instead
1005 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/
H A Drules.sql997 create table rules_base(f1 int, f2 int); table
998 insert into rules_base values(1,2), (11,12);
999 create rule r1 as on update to rules_base do instead
1000 select * from rules_base where f1 = 1 for update;
1001 update rules_base set f2 = f2 + 1;
1002 create or replace rule r1 as on update to rules_base do instead
1003 select * from rules_base where f1 = 11 for update of rules_base;
1004 update rules_base set f2 = f2 + 1;
1005 create or replace rule r1 as on update to rules_base do instead
1006 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/
H A Drules.sql997 create table rules_base(f1 int, f2 int); table
998 insert into rules_base values(1,2), (11,12);
999 create rule r1 as on update to rules_base do instead
1000 select * from rules_base where f1 = 1 for update;
1001 update rules_base set f2 = f2 + 1;
1002 create or replace rule r1 as on update to rules_base do instead
1003 select * from rules_base where f1 = 11 for update of rules_base;
1004 update rules_base set f2 = f2 + 1;
1005 create or replace rule r1 as on update to rules_base do instead
1006 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/
H A Drules.sql997 create table rules_base(f1 int, f2 int); table
998 insert into rules_base values(1,2), (11,12);
999 create rule r1 as on update to rules_base do instead
1000 select * from rules_base where f1 = 1 for update;
1001 update rules_base set f2 = f2 + 1;
1002 create or replace rule r1 as on update to rules_base do instead
1003 select * from rules_base where f1 = 11 for update of rules_base;
1004 update rules_base set f2 = f2 + 1;
1005 create or replace rule r1 as on update to rules_base do instead
1006 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/
H A Drules.sql997 create table rules_base(f1 int, f2 int); table
998 insert into rules_base values(1,2), (11,12);
999 create rule r1 as on update to rules_base do instead
1000 select * from rules_base where f1 = 1 for update;
1001 update rules_base set f2 = f2 + 1;
1002 create or replace rule r1 as on update to rules_base do instead
1003 select * from rules_base where f1 = 11 for update of rules_base;
1004 update rules_base set f2 = f2 + 1;
1005 create or replace rule r1 as on update to rules_base do instead
1006 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/
H A Drules.sql997 create table rules_base(f1 int, f2 int); table
998 insert into rules_base values(1,2), (11,12);
999 create rule r1 as on update to rules_base do instead
1000 select * from rules_base where f1 = 1 for update;
1001 update rules_base set f2 = f2 + 1;
1002 create or replace rule r1 as on update to rules_base do instead
1003 select * from rules_base where f1 = 11 for update of rules_base;
1004 update rules_base set f2 = f2 + 1;
1005 create or replace rule r1 as on update to rules_base do instead
1006 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql13-plpython/postgresql-13.5/src/test/regress/sql/
H A Drules.sql997 create table rules_base(f1 int, f2 int); table
998 insert into rules_base values(1,2), (11,12);
999 create rule r1 as on update to rules_base do instead
1000 select * from rules_base where f1 = 1 for update;
1001 update rules_base set f2 = f2 + 1;
1002 create or replace rule r1 as on update to rules_base do instead
1003 select * from rules_base where f1 = 11 for update of rules_base;
1004 update rules_base set f2 = f2 + 1;
1005 create or replace rule r1 as on update to rules_base do instead
1006 select * from rules_base where f1 = 11 for update of old; -- error
[all …]
/dports/databases/postgresql13-pltcl/postgresql-13.5/src/test/regress/sql/
H A Drules.sql997 create table rules_base(f1 int, f2 int); table
998 insert into rules_base values(1,2), (11,12);
999 create rule r1 as on update to rules_base do instead
1000 select * from rules_base where f1 = 1 for update;
1001 update rules_base set f2 = f2 + 1;
1002 create or replace rule r1 as on update to rules_base do instead
1003 select * from rules_base where f1 = 11 for update of rules_base;
1004 update rules_base set f2 = f2 + 1;
1005 create or replace rule r1 as on update to rules_base do instead
1006 select * from rules_base where f1 = 11 for update of old; -- error
[all …]

12345