/dports/databases/postgresql96-server/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 4 insert into T_pkey1 values (1, 'key1-1', 'test key'); 5 insert into T_pkey1 values (1, 'key1-2', 'test key'); 6 insert into T_pkey1 values (1, 'key1-3', 'test key'); 7 insert into T_pkey1 values (2, 'key2-1', 'test key'); 8 insert into T_pkey1 values (2, 'key2-2', 'test key'); 9 insert into T_pkey1 values (2, 'key2-3', 'test key'); 18 select * from T_pkey1; 56 select * from T_pkey1; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; [all …]
|
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 4 insert into T_pkey1 values (1, 'key1-1', 'test key'); 5 insert into T_pkey1 values (1, 'key1-2', 'test key'); 6 insert into T_pkey1 values (1, 'key1-3', 'test key'); 7 insert into T_pkey1 values (2, 'key2-1', 'test key'); 8 insert into T_pkey1 values (2, 'key2-2', 'test key'); 9 insert into T_pkey1 values (2, 'key2-3', 'test key'); 18 select * from T_pkey1; 56 select * from T_pkey1; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; [all …]
|
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 4 insert into T_pkey1 values (1, 'key1-1', 'test key'); 5 insert into T_pkey1 values (1, 'key1-2', 'test key'); 6 insert into T_pkey1 values (1, 'key1-3', 'test key'); 7 insert into T_pkey1 values (2, 'key2-1', 'test key'); 8 insert into T_pkey1 values (2, 'key2-2', 'test key'); 9 insert into T_pkey1 values (2, 'key2-3', 'test key'); 18 select * from T_pkey1; 56 select * from T_pkey1; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; [all …]
|
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 4 insert into T_pkey1 values (1, 'key1-1', 'test key'); 5 insert into T_pkey1 values (1, 'key1-2', 'test key'); 6 insert into T_pkey1 values (1, 'key1-3', 'test key'); 7 insert into T_pkey1 values (2, 'key2-1', 'test key'); 8 insert into T_pkey1 values (2, 'key2-2', 'test key'); 9 insert into T_pkey1 values (2, 'key2-3', 'test key'); 18 select * from T_pkey1; 56 select * from T_pkey1; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; [all …]
|
/dports/databases/postgresql96-docs/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 4 insert into T_pkey1 values (1, 'key1-1', 'test key'); 5 insert into T_pkey1 values (1, 'key1-2', 'test key'); 6 insert into T_pkey1 values (1, 'key1-3', 'test key'); 7 insert into T_pkey1 values (2, 'key2-1', 'test key'); 8 insert into T_pkey1 values (2, 'key2-2', 'test key'); 9 insert into T_pkey1 values (2, 'key2-3', 'test key'); 18 select * from T_pkey1; 56 select * from T_pkey1; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; [all …]
|
/dports/databases/postgresql96-client/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 4 insert into T_pkey1 values (1, 'key1-1', 'test key'); 5 insert into T_pkey1 values (1, 'key1-2', 'test key'); 6 insert into T_pkey1 values (1, 'key1-3', 'test key'); 7 insert into T_pkey1 values (2, 'key2-1', 'test key'); 8 insert into T_pkey1 values (2, 'key2-2', 'test key'); 9 insert into T_pkey1 values (2, 'key2-3', 'test key'); 18 select * from T_pkey1; 56 select * from T_pkey1; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; [all …]
|
/dports/databases/postgresql96-contrib/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 4 insert into T_pkey1 values (1, 'key1-1', 'test key'); 5 insert into T_pkey1 values (1, 'key1-2', 'test key'); 6 insert into T_pkey1 values (1, 'key1-3', 'test key'); 7 insert into T_pkey1 values (2, 'key2-1', 'test key'); 8 insert into T_pkey1 values (2, 'key2-2', 'test key'); 9 insert into T_pkey1 values (2, 'key2-3', 'test key'); 18 select * from T_pkey1; 56 select * from T_pkey1; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; [all …]
|
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 4 insert into T_pkey1 values (1, 'key1-1', 'test key'); 5 insert into T_pkey1 values (1, 'key1-2', 'test key'); 6 insert into T_pkey1 values (1, 'key1-3', 'test key'); 7 insert into T_pkey1 values (2, 'key2-1', 'test key'); 8 insert into T_pkey1 values (2, 'key2-2', 'test key'); 9 insert into T_pkey1 values (2, 'key2-3', 'test key'); 18 select * from T_pkey1; 56 select * from T_pkey1; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; [all …]
|
/dports/databases/postgresql10-contrib/postgresql-10.19/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 4 insert into T_pkey1 values (1, 'key1-1', 'test key'); 5 insert into T_pkey1 values (1, 'key1-2', 'test key'); 6 insert into T_pkey1 values (1, 'key1-3', 'test key'); 7 insert into T_pkey1 values (2, 'key2-1', 'test key'); 8 insert into T_pkey1 values (2, 'key2-2', 'test key'); 9 insert into T_pkey1 values (2, 'key2-3', 'test key'); 18 select * from T_pkey1; 56 select * from T_pkey1; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; [all …]
|
/dports/databases/postgresql10-client/postgresql-10.19/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 4 insert into T_pkey1 values (1, 'key1-1', 'test key'); 5 insert into T_pkey1 values (1, 'key1-2', 'test key'); 6 insert into T_pkey1 values (1, 'key1-3', 'test key'); 7 insert into T_pkey1 values (2, 'key2-1', 'test key'); 8 insert into T_pkey1 values (2, 'key2-2', 'test key'); 9 insert into T_pkey1 values (2, 'key2-3', 'test key'); 18 select * from T_pkey1; 56 select * from T_pkey1; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; [all …]
|
/dports/databases/postgresql10-plpython/postgresql-10.19/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 4 insert into T_pkey1 values (1, 'key1-1', 'test key'); 5 insert into T_pkey1 values (1, 'key1-2', 'test key'); 6 insert into T_pkey1 values (1, 'key1-3', 'test key'); 7 insert into T_pkey1 values (2, 'key2-1', 'test key'); 8 insert into T_pkey1 values (2, 'key2-2', 'test key'); 9 insert into T_pkey1 values (2, 'key2-3', 'test key'); 18 select * from T_pkey1; 56 select * from T_pkey1; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; [all …]
|
/dports/databases/postgresql10-docs/postgresql-10.19/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 4 insert into T_pkey1 values (1, 'key1-1', 'test key'); 5 insert into T_pkey1 values (1, 'key1-2', 'test key'); 6 insert into T_pkey1 values (1, 'key1-3', 'test key'); 7 insert into T_pkey1 values (2, 'key2-1', 'test key'); 8 insert into T_pkey1 values (2, 'key2-2', 'test key'); 9 insert into T_pkey1 values (2, 'key2-3', 'test key'); 18 select * from T_pkey1; 56 select * from T_pkey1; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; [all …]
|
/dports/databases/postgresql10-plperl/postgresql-10.19/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 4 insert into T_pkey1 values (1, 'key1-1', 'test key'); 5 insert into T_pkey1 values (1, 'key1-2', 'test key'); 6 insert into T_pkey1 values (1, 'key1-3', 'test key'); 7 insert into T_pkey1 values (2, 'key2-1', 'test key'); 8 insert into T_pkey1 values (2, 'key2-2', 'test key'); 9 insert into T_pkey1 values (2, 'key2-3', 'test key'); 18 select * from T_pkey1; 56 select * from T_pkey1; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; [all …]
|
/dports/databases/postgresql10-server/postgresql-10.19/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 4 insert into T_pkey1 values (1, 'key1-1', 'test key'); 5 insert into T_pkey1 values (1, 'key1-2', 'test key'); 6 insert into T_pkey1 values (1, 'key1-3', 'test key'); 7 insert into T_pkey1 values (2, 'key2-1', 'test key'); 8 insert into T_pkey1 values (2, 'key2-2', 'test key'); 9 insert into T_pkey1 values (2, 'key2-3', 'test key'); 18 select * from T_pkey1; 56 select * from T_pkey1; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; [all …]
|
/dports/databases/postgresql12-client/postgresql-12.9/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 16 create table T_pkey1 ( table 471 insert into T_pkey1 values (1, 'key1-1', 'test key'); 472 insert into T_pkey1 values (1, 'key1-2', 'test key'); 473 insert into T_pkey1 values (1, 'key1-3', 'test key'); 474 insert into T_pkey1 values (2, 'key2-1', 'test key'); 485 select * from T_pkey1; 523 select * from T_pkey1; 528 select tcl_avg(key1) from T_pkey1; 529 select tcl_sum(key1) from T_pkey1; 534 select tcl_avg(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 16 create table T_pkey1 ( table 471 insert into T_pkey1 values (1, 'key1-1', 'test key'); 472 insert into T_pkey1 values (1, 'key1-2', 'test key'); 473 insert into T_pkey1 values (1, 'key1-3', 'test key'); 474 insert into T_pkey1 values (2, 'key2-1', 'test key'); 485 select * from T_pkey1; 523 select * from T_pkey1; 528 select tcl_avg(key1) from T_pkey1; 529 select tcl_sum(key1) from T_pkey1; 534 select tcl_avg(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql14-server/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 16 create table T_pkey1 ( table 471 insert into T_pkey1 values (1, 'key1-1', 'test key'); 472 insert into T_pkey1 values (1, 'key1-2', 'test key'); 473 insert into T_pkey1 values (1, 'key1-3', 'test key'); 474 insert into T_pkey1 values (2, 'key2-1', 'test key'); 485 select * from T_pkey1; 523 select * from T_pkey1; 528 select tcl_avg(key1) from T_pkey1; 529 select tcl_sum(key1) from T_pkey1; 534 select tcl_avg(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 16 create table T_pkey1 ( table 471 insert into T_pkey1 values (1, 'key1-1', 'test key'); 472 insert into T_pkey1 values (1, 'key1-2', 'test key'); 473 insert into T_pkey1 values (1, 'key1-3', 'test key'); 474 insert into T_pkey1 values (2, 'key2-1', 'test key'); 485 select * from T_pkey1; 523 select * from T_pkey1; 528 select tcl_avg(key1) from T_pkey1; 529 select tcl_sum(key1) from T_pkey1; 534 select tcl_avg(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 16 create table T_pkey1 ( table 471 insert into T_pkey1 values (1, 'key1-1', 'test key'); 472 insert into T_pkey1 values (1, 'key1-2', 'test key'); 473 insert into T_pkey1 values (1, 'key1-3', 'test key'); 474 insert into T_pkey1 values (2, 'key2-1', 'test key'); 485 select * from T_pkey1; 523 select * from T_pkey1; 528 select tcl_avg(key1) from T_pkey1; 529 select tcl_sum(key1) from T_pkey1; 534 select tcl_avg(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 16 create table T_pkey1 ( table 471 insert into T_pkey1 values (1, 'key1-1', 'test key'); 472 insert into T_pkey1 values (1, 'key1-2', 'test key'); 473 insert into T_pkey1 values (1, 'key1-3', 'test key'); 474 insert into T_pkey1 values (2, 'key2-1', 'test key'); 485 select * from T_pkey1; 523 select * from T_pkey1; 528 select tcl_avg(key1) from T_pkey1; 529 select tcl_sum(key1) from T_pkey1; 534 select tcl_avg(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql13-pltcl/postgresql-13.5/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 16 create table T_pkey1 ( table 471 insert into T_pkey1 values (1, 'key1-1', 'test key'); 472 insert into T_pkey1 values (1, 'key1-2', 'test key'); 473 insert into T_pkey1 values (1, 'key1-3', 'test key'); 474 insert into T_pkey1 values (2, 'key2-1', 'test key'); 485 select * from T_pkey1; 523 select * from T_pkey1; 528 select tcl_avg(key1) from T_pkey1; 529 select tcl_sum(key1) from T_pkey1; 534 select tcl_avg(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql14-contrib/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 16 create table T_pkey1 ( table 471 insert into T_pkey1 values (1, 'key1-1', 'test key'); 472 insert into T_pkey1 values (1, 'key1-2', 'test key'); 473 insert into T_pkey1 values (1, 'key1-3', 'test key'); 474 insert into T_pkey1 values (2, 'key2-1', 'test key'); 485 select * from T_pkey1; 523 select * from T_pkey1; 528 select tcl_avg(key1) from T_pkey1; 529 select tcl_sum(key1) from T_pkey1; 534 select tcl_avg(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql13-server/postgresql-13.5/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 16 create table T_pkey1 ( table 471 insert into T_pkey1 values (1, 'key1-1', 'test key'); 472 insert into T_pkey1 values (1, 'key1-2', 'test key'); 473 insert into T_pkey1 values (1, 'key1-3', 'test key'); 474 insert into T_pkey1 values (2, 'key2-1', 'test key'); 485 select * from T_pkey1; 523 select * from T_pkey1; 528 select tcl_avg(key1) from T_pkey1; 529 select tcl_sum(key1) from T_pkey1; 534 select tcl_avg(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql14-client/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 16 create table T_pkey1 ( table 471 insert into T_pkey1 values (1, 'key1-1', 'test key'); 472 insert into T_pkey1 values (1, 'key1-2', 'test key'); 473 insert into T_pkey1 values (1, 'key1-3', 'test key'); 474 insert into T_pkey1 values (2, 'key2-1', 'test key'); 485 select * from T_pkey1; 523 select * from T_pkey1; 528 select tcl_avg(key1) from T_pkey1; 529 select tcl_sum(key1) from T_pkey1; 534 select tcl_avg(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql13-contrib/postgresql-13.5/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 16 create table T_pkey1 ( table 471 insert into T_pkey1 values (1, 'key1-1', 'test key'); 472 insert into T_pkey1 values (1, 'key1-2', 'test key'); 473 insert into T_pkey1 values (1, 'key1-3', 'test key'); 474 insert into T_pkey1 values (2, 'key2-1', 'test key'); 485 select * from T_pkey1; 523 select * from T_pkey1; 528 select tcl_avg(key1) from T_pkey1; 529 select tcl_sum(key1) from T_pkey1; 534 select tcl_avg(key1) from T_pkey1 where key1 = 99; [all …]
|