Re: [GENERAL] Triggers and sql functions not working...

>>>>> "GY" == Greg Youngblood <YoungblG(at)houstoncellular(dot)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(at)icomm(dot)ru
Senior programmer