Re: Trigger, record "old" is not assigned yet

On 7/13/06, Adrian Klaver <aklaver(at)comcast(dot)net> wrote:
>
> 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(at)comcast(dot)net

Or to be more specific:

IF (TG_OP = 'UPDATE') THEN

==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
==================================================================