Re: after insert or update or delete of col2

["Rafael Montoya" <rafo-mm@xxxxxxxxxxx>]

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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org