Default value on tables column set in trigger on insert !
Is possible to set value of tables column in trigger on insert on same
table ?
Example
create table test(ifxid serial(1), id integer);
create trigger test_trig insert on test
referencing new as new
for each row{ and now important }
(new.id=new.ifxid);
{ or maybe }
(update test set id=new.ifxid where ifxid=new.ifxid);
Thanks for any answers with solution !
Karol Kowalski
(karol@finskog.com.pl)