/dports/databases/postgresql11-client/postgresql-11.14/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 28 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 29 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 30 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 33 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 42 select * from T_dta1; 58 select * from T_dta1; 94 create domain d_dta1 as T_dta1 check ((value).ref1 > 0); 100 select tcl_record_arg(row('tkey', 42, 'ref2')::T_dta1, 'ref1'); 109 select tcl_cdomain_arg(row('tkey', 42, 'ref2')::T_dta1); 160 create function tcl_composite_result(int) returns T_dta1 as $$
|
/dports/databases/postgresql11-plperl/postgresql-11.14/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 28 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 29 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 30 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 33 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 42 select * from T_dta1; 58 select * from T_dta1; 94 create domain d_dta1 as T_dta1 check ((value).ref1 > 0); 100 select tcl_record_arg(row('tkey', 42, 'ref2')::T_dta1, 'ref1'); 109 select tcl_cdomain_arg(row('tkey', 42, 'ref2')::T_dta1); 160 create function tcl_composite_result(int) returns T_dta1 as $$
|
/dports/databases/postgresql11-contrib/postgresql-11.14/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 28 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 29 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 30 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 33 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 42 select * from T_dta1; 58 select * from T_dta1; 94 create domain d_dta1 as T_dta1 check ((value).ref1 > 0); 100 select tcl_record_arg(row('tkey', 42, 'ref2')::T_dta1, 'ref1'); 109 select tcl_cdomain_arg(row('tkey', 42, 'ref2')::T_dta1); 160 create function tcl_composite_result(int) returns T_dta1 as $$
|
/dports/databases/postgresql11-docs/postgresql-11.14/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 28 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 29 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 30 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 33 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 42 select * from T_dta1; 58 select * from T_dta1; 94 create domain d_dta1 as T_dta1 check ((value).ref1 > 0); 100 select tcl_record_arg(row('tkey', 42, 'ref2')::T_dta1, 'ref1'); 109 select tcl_cdomain_arg(row('tkey', 42, 'ref2')::T_dta1); 160 create function tcl_composite_result(int) returns T_dta1 as $$
|
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 28 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 29 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 30 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 33 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 42 select * from T_dta1; 58 select * from T_dta1; 94 create domain d_dta1 as T_dta1 check ((value).ref1 > 0); 100 select tcl_record_arg(row('tkey', 42, 'ref2')::T_dta1, 'ref1'); 109 select tcl_cdomain_arg(row('tkey', 42, 'ref2')::T_dta1); 160 create function tcl_composite_result(int) returns T_dta1 as $$
|
/dports/databases/postgresql11-plpython/postgresql-11.14/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 28 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 29 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 30 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 33 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 42 select * from T_dta1; 58 select * from T_dta1; 94 create domain d_dta1 as T_dta1 check ((value).ref1 > 0); 100 select tcl_record_arg(row('tkey', 42, 'ref2')::T_dta1, 'ref1'); 109 select tcl_cdomain_arg(row('tkey', 42, 'ref2')::T_dta1); 160 create function tcl_composite_result(int) returns T_dta1 as $$
|
/dports/databases/postgresql11-server/postgresql-11.14/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 28 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 29 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 30 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 33 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 42 select * from T_dta1; 58 select * from T_dta1; 94 create domain d_dta1 as T_dta1 check ((value).ref1 > 0); 100 select tcl_record_arg(row('tkey', 42, 'ref2')::T_dta1, 'ref1'); 109 select tcl_cdomain_arg(row('tkey', 42, 'ref2')::T_dta1); 160 create function tcl_composite_result(int) returns T_dta1 as $$
|
/dports/databases/postgresql96-server/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 28 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 29 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 30 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 33 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 42 select * from T_dta1; 58 select * from T_dta1;
|
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 28 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 29 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 30 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 33 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 42 select * from T_dta1; 58 select * from T_dta1;
|
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 28 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 29 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 30 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 33 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 42 select * from T_dta1; 58 select * from T_dta1;
|
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 28 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 29 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 30 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 33 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 42 select * from T_dta1; 58 select * from T_dta1;
|
/dports/databases/postgresql96-docs/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 28 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 29 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 30 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 33 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 42 select * from T_dta1; 58 select * from T_dta1;
|
/dports/databases/postgresql96-client/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 28 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 29 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 30 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 33 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 42 select * from T_dta1; 58 select * from T_dta1;
|
/dports/databases/postgresql96-contrib/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 28 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 29 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 30 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 33 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 42 select * from T_dta1; 58 select * from T_dta1;
|
/dports/databases/postgresql12-client/postgresql-12.9/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 28 create table T_dta1 ( table 461 create trigger dta1_before before insert or update on T_dta1 495 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 496 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 497 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 500 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 509 select * from T_dta1; 525 select * from T_dta1;
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 28 create table T_dta1 ( table 461 create trigger dta1_before before insert or update on T_dta1 495 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 496 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 497 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 500 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 509 select * from T_dta1; 525 select * from T_dta1;
|
/dports/databases/postgresql14-server/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 28 create table T_dta1 ( table 461 create trigger dta1_before before insert or update on T_dta1 495 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 496 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 497 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 500 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 509 select * from T_dta1; 525 select * from T_dta1;
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 28 create table T_dta1 ( table 461 create trigger dta1_before before insert or update on T_dta1 495 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 496 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 497 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 500 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 509 select * from T_dta1; 525 select * from T_dta1;
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 28 create table T_dta1 ( table 461 create trigger dta1_before before insert or update on T_dta1 495 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 496 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 497 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 500 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 509 select * from T_dta1; 525 select * from T_dta1;
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 28 create table T_dta1 ( table 461 create trigger dta1_before before insert or update on T_dta1 495 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 496 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 497 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 500 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 509 select * from T_dta1; 525 select * from T_dta1;
|
/dports/databases/postgresql13-pltcl/postgresql-13.5/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 28 create table T_dta1 ( table 461 create trigger dta1_before before insert or update on T_dta1 495 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 496 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 497 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 500 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 509 select * from T_dta1; 525 select * from T_dta1;
|
/dports/databases/postgresql14-contrib/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 28 create table T_dta1 ( table 461 create trigger dta1_before before insert or update on T_dta1 495 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 496 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 497 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 500 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 509 select * from T_dta1; 525 select * from T_dta1;
|
/dports/databases/postgresql13-server/postgresql-13.5/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 28 create table T_dta1 ( table 461 create trigger dta1_before before insert or update on T_dta1 495 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 496 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 497 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 500 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 509 select * from T_dta1; 525 select * from T_dta1;
|
/dports/databases/postgresql14-client/postgresql-14.1/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 28 create table T_dta1 ( table 461 create trigger dta1_before before insert or update on T_dta1 495 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 496 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 497 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 500 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 509 select * from T_dta1; 525 select * from T_dta1;
|
/dports/databases/postgresql13-contrib/postgresql-13.5/src/pl/tcl/sql/ |
H A D | pltcl_trigger.sql | 28 create table T_dta1 ( table 461 create trigger dta1_before before insert or update on T_dta1 495 insert into T_dta1 values ('trec 1', 1, 'key1-1'); 496 insert into T_dta1 values ('trec 2', 1, 'key1-2'); 497 insert into T_dta1 values ('trec 3', 1, 'key1-3'); 500 insert into T_dta1 values ('trec 4', 1, 'key1-4'); 509 select * from T_dta1; 525 select * from T_dta1;
|