Re: trigger : emulate "instead of" with before ? - Mailing list pgsql-sql

"Albrecht Berger" <berger1517@gmx.ch> writes:
> I need a trigger which is updating a delete flag of a row instead of
> deleting it physically.

> How do I implement a trigger which doesn't execute a delete without raising
> an exception in plsql ?

If the BEFORE DELETE trigger returns NULL, the delete is skipped.
        regards, tom lane