Re: Trigger function that works with both updates and deletes?

Perfect, thanks

Michael Fuhr wrote:
>
> On Mon, Jun 18, 2007 at 06:07:37PM -0700, novnov wrote:
>> First, when a record is being deleted, OLD refers to the rec just deleted
>> (or about to be deleted)?
>
> Correct.
>
>> Second, while I could write two trigger functions, one dealing with
>> add/update, the other with deletes, it's probably neater to have a single
>> trigger function and have it discriminate "am I being called for a
>> delete,
>> or an add/update?" I don't know how to determine the type record change.
>
> In PL/pgSQL you can use TG_OP. See "Trigger Procedures" in the
> documentation:
>
> http://www.postgresql.org/docs/8.2/interactive/plpgsql-trigger.html
>
> --
> Michael Fuhr
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
>

--
View this message in context: http://www.nabble.com/Trigger-function-that-works-with-both-updates-and-deletes--tf3943732.html#a11189206
Sent from the PostgreSQL - general mailing list archive at Nabble.com.