Re: triggering on deletes, NEW row or OLD row?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Peter(at)berghold(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: triggering on deletes, NEW row or OLD row?
Date: 2005-12-13 20:45:31
Message-ID: 439F32EB.7080401@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Rysdam 2005-12-13 20:50:40 Re: "incomplete startup packet" on SGI
Previous Message Richard Huxton 2005-12-13 20:44:28 Re: php + postgresql pg_connect problem