Le mercredi 9 décembre 2009 à 17:04:32, George Silva a écrit :
> Hello all again :)
>
> I have a question: is it possible to replicate the behavior of a rule
> INSTEAD of with a TRIGGER?
>
> For some specific reasons i need to use a trigger to update a
> secondary table, but i don't want the changes to happen in the primary
> table too.
>
> Is it possible to do it? If so, how?
>
Try a BEFORE trigger, and RETURN NULL in your stored function.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com