/dports/databases/postgresql96-server/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 11 insert into T_pkey2 values (1, 'key1-1', 'test key'); 12 insert into T_pkey2 values (1, 'key1-2', 'test key'); 13 insert into T_pkey2 values (1, 'key1-3', 'test key'); 14 insert into T_pkey2 values (2, 'key2-1', 'test key'); 15 insert into T_pkey2 values (2, 'key2-2', 'test key'); 16 insert into T_pkey2 values (2, 'key2-3', 'test key'); 21 select * from T_pkey2; 26 insert into T_pkey2 values (1, 'KEY1-3', 'should fail'); 57 select * from T_pkey2; 63 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 11 insert into T_pkey2 values (1, 'key1-1', 'test key'); 12 insert into T_pkey2 values (1, 'key1-2', 'test key'); 13 insert into T_pkey2 values (1, 'key1-3', 'test key'); 14 insert into T_pkey2 values (2, 'key2-1', 'test key'); 15 insert into T_pkey2 values (2, 'key2-2', 'test key'); 16 insert into T_pkey2 values (2, 'key2-3', 'test key'); 21 select * from T_pkey2; 26 insert into T_pkey2 values (1, 'KEY1-3', 'should fail'); 57 select * from T_pkey2; 63 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 11 insert into T_pkey2 values (1, 'key1-1', 'test key'); 12 insert into T_pkey2 values (1, 'key1-2', 'test key'); 13 insert into T_pkey2 values (1, 'key1-3', 'test key'); 14 insert into T_pkey2 values (2, 'key2-1', 'test key'); 15 insert into T_pkey2 values (2, 'key2-2', 'test key'); 16 insert into T_pkey2 values (2, 'key2-3', 'test key'); 21 select * from T_pkey2; 26 insert into T_pkey2 values (1, 'KEY1-3', 'should fail'); 57 select * from T_pkey2; 63 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 11 insert into T_pkey2 values (1, 'key1-1', 'test key'); 12 insert into T_pkey2 values (1, 'key1-2', 'test key'); 13 insert into T_pkey2 values (1, 'key1-3', 'test key'); 14 insert into T_pkey2 values (2, 'key2-1', 'test key'); 15 insert into T_pkey2 values (2, 'key2-2', 'test key'); 16 insert into T_pkey2 values (2, 'key2-3', 'test key'); 21 select * from T_pkey2; 26 insert into T_pkey2 values (1, 'KEY1-3', 'should fail'); 57 select * from T_pkey2; 63 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql96-docs/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 11 insert into T_pkey2 values (1, 'key1-1', 'test key'); 12 insert into T_pkey2 values (1, 'key1-2', 'test key'); 13 insert into T_pkey2 values (1, 'key1-3', 'test key'); 14 insert into T_pkey2 values (2, 'key2-1', 'test key'); 15 insert into T_pkey2 values (2, 'key2-2', 'test key'); 16 insert into T_pkey2 values (2, 'key2-3', 'test key'); 21 select * from T_pkey2; 26 insert into T_pkey2 values (1, 'KEY1-3', 'should fail'); 57 select * from T_pkey2; 63 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql96-client/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 11 insert into T_pkey2 values (1, 'key1-1', 'test key'); 12 insert into T_pkey2 values (1, 'key1-2', 'test key'); 13 insert into T_pkey2 values (1, 'key1-3', 'test key'); 14 insert into T_pkey2 values (2, 'key2-1', 'test key'); 15 insert into T_pkey2 values (2, 'key2-2', 'test key'); 16 insert into T_pkey2 values (2, 'key2-3', 'test key'); 21 select * from T_pkey2; 26 insert into T_pkey2 values (1, 'KEY1-3', 'should fail'); 57 select * from T_pkey2; 63 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql96-contrib/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 11 insert into T_pkey2 values (1, 'key1-1', 'test key'); 12 insert into T_pkey2 values (1, 'key1-2', 'test key'); 13 insert into T_pkey2 values (1, 'key1-3', 'test key'); 14 insert into T_pkey2 values (2, 'key2-1', 'test key'); 15 insert into T_pkey2 values (2, 'key2-2', 'test key'); 16 insert into T_pkey2 values (2, 'key2-3', 'test key'); 21 select * from T_pkey2; 26 insert into T_pkey2 values (1, 'KEY1-3', 'should fail'); 57 select * from T_pkey2; 63 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql12-client/postgresql-12.9/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql14-server/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql13-pltcl/postgresql-13.5/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql14-contrib/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql13-server/postgresql-13.5/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql14-client/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql13-contrib/postgresql-13.5/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql12-contrib/postgresql-12.9/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql12-docs/postgresql-12.9/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql12-server/postgresql-12.9/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql13-client/postgresql-13.5/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql12-plpython/postgresql-12.9/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql12-plperl/postgresql-12.9/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|
/dports/databases/postgresql13-plpython/postgresql-13.5/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 22 create table T_pkey2 ( table 478 insert into T_pkey2 values (1, 'key1-1', 'test key'); 479 insert into T_pkey2 values (1, 'key1-2', 'test key'); 480 insert into T_pkey2 values (1, 'key1-3', 'test key'); 481 insert into T_pkey2 values (2, 'key2-1', 'test key'); 482 insert into T_pkey2 values (2, 'key2-2', 'test key'); 483 insert into T_pkey2 values (2, 'key2-3', 'test key'); 488 select * from T_pkey2; 524 select * from T_pkey2; 530 select tcl_avg(key1) from T_pkey2; [all …]
|