Re: after insert or update or delete of col2

From: "Rafael Montoya" <rafo-mm(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: after insert or update or delete of col2
Date: 2005-10-31 23:33:47
Message-ID: BAY18-F5C98FD42B8F7F6D7EC0C3F86C0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-10-31 23:50:34 Re: insert multiple rows
Previous Message MaXX 2005-10-31 23:32:46 Re: SQL injection