tcl/sql/pltcl_trigger.sql

22 create table T_pkey2 (  table
273 create trigger pkey2_before before insert or update on T_pkey2
363 create trigger pkey2_after after update or delete on T_pkey2
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;
493 insert into T_pkey2 values (1, 'KEY1-3', 'should fail');
518 update T_pkey2 set key2 = 'KEY2-9' where key1 = 2 and key2 = 'KEY2-1';
519 update T_pkey2 set key2 = 'KEY1-9' where key1 = 1 and key2 = 'KEY1-1';
520 delete from T_pkey2 where key1 = 2 and key2 = 'KEY2-2';
521 delete from T_pkey2 where key1 = 1 and key2 = 'KEY1-2';
524 select * from T_pkey2;
530 select tcl_avg(key1) from T_pkey2;
531 select tcl_sum(key1) from T_pkey2;
541 select * from T_pkey2 order by key1 using @<, key2 collate "C";