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

From Adrian Klaver
Subject Re: Trigger, record "old" is not assigned yet
Date
Msg-id 200607131638.54001.aklaver@comcast.net
Whole thread Raw
In response to Trigger, record "old" is not assigned yet  ("Daniel Caune" <daniel.caune@ubisoft.com>)
Responses Re: Trigger, record "old" is not assigned yet
List pgsql-sql
For plpgsql use TG_OP. See link below.
http://www.postgresql.org/docs/8.1/interactive/plpgsql-trigger.html
On Thursday 13 July 2006 03:50 pm, Daniel Caune wrote:
> 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

-- 
Adrian Klaver    
aklaver@comcast.net


pgsql-sql by date:

Previous
From: "Daniel Caune"
Date:
Subject: Trigger, record "old" is not assigned yet
Next
From: "Aaron Bono"
Date:
Subject: Re: Trigger, record "old" is not assigned yet