Re: Instead of Triggers - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Instead of Triggers
Date
Msg-id 20061029162712.GC2388@alvh.no-ip.org
Whole thread Raw
In response to Re: Instead of Triggers  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Michael Fuhr wrote:
> On Fri, Oct 27, 2006 at 05:49:19PM +0530, chelliah gabriel - Sun Microsystems - Bangalore India wrote:
> > Does PG support Instead of Triggers?.
>
> PostgreSQL has INSTEAD OF rules.

It also has the ability to prevent the execution of the action which
triggered the, um, trigger (by returning NULL in a BEFORE/FOR EACH ROW
trigger), while executing a different action (say, inserting in a
different table).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Modifying SQL parser with extensions?
Next
From: Richard Troy
Date:
Subject: Re: Modifying SQL parser with extensions?