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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster