Trigger, record "old" is not assigned yet - Mailing list pgsql-sql

From Daniel Caune
Subject Trigger, record "old" is not assigned yet
Date
Msg-id 1E293D3FF63A3740B10AD5AAD88535D202A29F60@UBIMAIL1.ubisoft.org
Whole thread Raw
Responses Re: Trigger, record "old" is not assigned yet
List 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

 

pgsql-sql by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: How to find entries missing in 2nd table?
Next
From: Adrian Klaver
Date:
Subject: Re: Trigger, record "old" is not assigned yet