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

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: novnov <novnovice(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Trigger function that works with both updates and deletes?
Date: 2007-06-19 01:36:59
Message-ID: 20070619013659.GA16834@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Harvey, Allan AC 2007-06-19 01:46:35 Re: Trigger function that works with both updates and deletes?
Previous Message novnov 2007-06-19 01:07:37 Trigger function that works with both updates and deletes?