Trigger, record "old" is not assigned yet

From: "Daniel Caune" <daniel(dot)caune(at)ubisoft(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Trigger, record "old" is not assigned yet
Date: 2006-07-13 22:50:01
Message-ID: 1E293D3FF63A3740B10AD5AAD88535D202A29F60@UBIMAIL1.ubisoft.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I've created a trigger BEFORE INSERT OR UPDATE on a table and, indeed,
when the trigger is raised before insertion the record "old" is not
assigned. Is there a way to distinguish in the trigger procedure from
an insert statement to an update statement?

Regards,

--

Daniel CAUNE

Ubisoft Online Technology

(514) 490 2040 ext. 3613

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2006-07-13 23:38:53 Re: Trigger, record "old" is not assigned yet
Previous Message Richard Broersma Jr 2006-07-13 16:33:52 Re: How to find entries missing in 2nd table?