Re: after insert or update or delete of col2 - Mailing list pgsql-general

I have this statement in oracle:

     CREATE OR REPLACE TRIGGER trig
     AFTER INSERT OR UPDATE OR DELETE OF column2              <<----- Here
is the doubt
     ON table_product
     FOR EACH ROW
     BEGIN
     ...
     END

Migrating to PostgreSQL,  the conditionals for AFTER UPDATE OF COLUMN2 in
trig() are:

    IF NEW.column2 <> OLD.column2 OR
       (NEW.column2 IS NULL) <> (OLD.column2 IS NULL) THEN
     ...
     END IF;

but, i can not found the conditionals for AFTER INSERT OF COL2 and AFTER
DELETE OF COL2, please, give me a hand.
Thanks
Rafael

_________________________________________________________________
Acepta el reto MSN Premium: Protección para tus hijos en internet.
Descárgalo y pruébalo 2 meses gratis.
http://join.msn.com?XAPID=1697&DI=1055&HL=Footer_mailsenviados_proteccioninfantil