>>>>> "GY" == Greg Youngblood <YoungblG@houstoncellular.com> 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: tolik@icomm.ru
Senior programmer