Обсуждение: Instead of Triggers

Hi,

Does PG support Instead of Triggers?.

Regards,
Gabriel

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.  Will that work?  What are you
trying to do?

http://www.postgresql.org/docs/8.1/interactive/sql-createrule.html
http://www.postgresql.org/docs/8.1/interactive/rules.html

--
Michael Fuhr

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.