>>>>> "GY" == Greg Youngblood <[EMAIL PROTECTED]> writes: . . . GY> create function update_tab2 () returns int4 as 'insert into tab2 (l,a,g) GY> select distinct a.l,b.a,b.c from tab2 a,tab1 b where b.a not in (select GY> distinct a from tab2); select 1 as exitvalue;' language 'sql'; . . . GY> create trigger new_tab1_a after insert on tab1 for each row execute GY> procedure update_tab2 (); GY> generates: GY> ERROR: CreateTrigger: function update_tab2 () does not exist. Function for triggers must have signature 'xxx() returns opaque', but not '... returns int'. Pehaps this is your mistake? -- Anatoly K. Lasareff Email: [EMAIL PROTECTED] Senior programmer
