#create table t_4_1 ("id" int, "name" varchar(1024));
#insert into t_4_1 values(10, 'monetdb');
[ 1	]
#insert into t_4_1 values(20, 'monet');
[ 1	]
#create trigger test_4_1
#	after update on t_4_1 referencing old row as old_row
#	for each statement insert into t_4_1 values(0, 'update_old_row_statement');
#create trigger test_4_2
#	after update on t_4_1 referencing new row new_row
#	for each statement insert into t_4_1 values(1, 'update_new_row_statement');
#create trigger test_4_3
#	after update on t_4_1
#	for each statement insert into t_4_1 values(2, 'update_statement');
#create trigger test_4_4
#	after update on t_4_1 referencing new row as new_row
#	for each row insert into t_4_1 values(3, 'update_row');
#create trigger test_4_6
#	after update on t_4_1 referencing new row as new_row
#	for each row 
#	when (new_row."id">0) insert into t_4_1 values(5, 'update_when_row_true');
#create trigger test_4_8
#	after update on t_4_1 referencing new row as new_row
#	for each row 
#	when (new_row."id">1000) insert into t_4_1 values(7, 'update_when_row_false');
#update t_4_1 set "name" = 'mo' where "id" = 10;
[ 1	]
#select * from t_4_1;
% sys.t_4_1,	sys.t_4_1 # table_name
% id,	name # name
% int,	varchar # type
% 2,	24 # length
[ 10,	"mo"	]
[ 20,	"monet"	]
[ 0,	"update_old_row_statement"	]
[ 1,	"update_new_row_statement"	]
[ 2,	"update_statement"	]
[ 3,	"update_row"	]
[ 5,	"update_when_row_true"	]
[ 7,	"update_when_row_false"	]
#delete from t_4_1 where "id" >-1;
[ 8	]
#drop trigger test_4_1;
#drop trigger test_4_2;
#drop trigger test_4_3;
#drop trigger test_4_4;
#drop trigger test_4_6;
#drop trigger test_4_8;
#insert into t_4_1 values(10, 'monetdb');
[ 1	]
#insert into t_4_1 values(20, 'monet');
[ 1	]
#create trigger test_4_1
#	after update on t_4_1
#	BEGIN ATOMIC
#		insert into t_4_1 values(1,'first_insertion');
#		insert into t_4_1 values(2,'second_insertion');
#	END;
#create trigger test_4_2
#	after update on t_4_1
#	BEGIN ATOMIC
#		insert into t_4_1 values(3,'third_insertion');
#	END;
#create trigger test_4_3
#	after update on t_4_1
#	BEGIN ATOMIC
#		insert into t_4_1 values(4,'fourth_insertion');
#		insert into t_4_1 values(5,'fifth_insertion');
#	END;
#update t_4_1 set "name" = 'mo' where "id" = 10;
[ 1	]
#select * from t_4_1;
% sys.t_4_1,	sys.t_4_1 # table_name
% id,	name # name
% int,	varchar # type
% 2,	16 # length
[ 10,	"mo"	]
[ 20,	"monet"	]
[ 1,	"first_insertion"	]
[ 2,	"second_insertion"	]
[ 3,	"third_insertion"	]
[ 4,	"fourth_insertion"	]
[ 5,	"fifth_insertion"	]
#drop trigger test_4_1;
#drop trigger test_4_2;
#drop trigger test_4_3;
#drop table t_4_1;