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

2001-10-24 Thread san
From [EMAIL PROTECTED] Tue Oct 23 18:33:27 2001 Content-Disposition: inline From: "Aasmund Midttun Godal" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [SQL] PL/pgSQL triggers ON INSERT OR UPDATE

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

2001-10-23 Thread Aasmund Midttun Godal
First, I may be wrong but I do think they would prefer if you did not cross-post (especially to hackers). Second I think it probably make more sense to make two different triggers here. If you really wanted to do it that way you might want to try executing that part. Regards, Aasmund. On Mon

[SQL] PL/pgSQL triggers ON INSERT OR UPDATE

2001-10-23 Thread san
Hello, I'm trying to set up a trigger on insert or update but when using the predefined variable ``OLD'' I get a NOTICE from the trigger function about OLD not being defined yet. Of course OLD is not defined when the function is triggered on INSERT event, and I did not mention it if not inside a