Re: [SQL] PL/pgSQL triggers ON INSERT OR UPDATE

2001-10-24 Thread san
ents, checks for TG_OP. Sorry about cross-posting attempt ;) please don't post that mail --san; ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that

[SQL] PL/pgSQL triggers ON INSERT OR UPDATE

2001-10-23 Thread san
IF END IF; END; Even when TG_OP != 'UPDATE' (INSERT event) I still get an error message from the pl/pgsql compiler (the first time the trigger is fired). What should I do then ? Is it still possible to use the same function for UPDATE OR INSERT events ? TIA -