From: Adrian Klaver <aklaver@comcast.net>
To: pgsql-sql@postgresql.org
Cc: Daniel Caune <daniel.caune@ubisoft.com>
Subject: Re: Trigger, record "old" is not assigned yet
Date: Thu, 13 Jul 2006 16:38:53 -0700
Message-ID: <200607131638.54001.aklaver@comcast.net> (raw)
In-Reply-To: <1E293D3FF63A3740B10AD5AAD88535D202A29F60@UBIMAIL1.ubisoft.org>
References: <1E293D3FF63A3740B10AD5AAD88535D202A29F60@UBIMAIL1.ubisoft.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: aklaver@comcast.net, daniel.caune@ubisoft.com
Subject: Re: Trigger, record "old" is not assigned yet
In-Reply-To: <200607131638.54001.aklaver@comcast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox