Home
last modified time | relevance | path

Searched refs:T_dta1 (Results 1 – 25 of 126) sorted by relevance

123456

/dports/databases/postgresql11-client/postgresql-11.14/src/pl/tcl/sql/
H A Dpltcl_queries.sql28 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 Dpltcl_queries.sql28 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 Dpltcl_queries.sql28 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 Dpltcl_queries.sql28 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 Dpltcl_queries.sql28 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 Dpltcl_queries.sql28 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 Dpltcl_queries.sql28 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 Dpltcl_queries.sql28 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 Dpltcl_queries.sql28 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 Dpltcl_queries.sql28 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 Dpltcl_queries.sql28 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 Dpltcl_queries.sql28 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 Dpltcl_queries.sql28 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 Dpltcl_queries.sql28 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 Dpltcl_trigger.sql28 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 Dpltcl_trigger.sql28 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 Dpltcl_trigger.sql28 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 Dpltcl_trigger.sql28 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 Dpltcl_trigger.sql28 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 Dpltcl_trigger.sql28 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 Dpltcl_trigger.sql28 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 Dpltcl_trigger.sql28 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 Dpltcl_trigger.sql28 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 Dpltcl_trigger.sql28 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 Dpltcl_trigger.sql28 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;

123456