Postgres Pro
Downloads
Home   >   mailing lists

Re: triggering on deletes, NEW row or OLD row? - Mailing list pgsql-general

From Richard Huxton
Subject Re: triggering on deletes, NEW row or OLD row?
Date
Msg-id 439F32EB.7080401@archonet.com
Whole thread Raw
In response to triggering on deletes, NEW row or OLD row?  ("Peter L. Berghold" <Peter@berghold.net>)
List pgsql-general
Tree view 
Peter L. Berghold wrote:
> The question I have is with a trigger on delete are the NEW and OLD
> system variables valid? Which one is valid?

OLD for deletes. NEW for inserts. Both for updates.

HTH
--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: php + postgresql pg_connect problem
Next
From: David Rysdam
Date:
Subject: Re: "incomplete startup packet" on SGI