Re: after insert or update or delete of col2
| От | Rafael Montoya |
|---|---|
| Тема | Re: after insert or update or delete of col2 |
| Дата | |
| Msg-id | BAY18-F5C98FD42B8F7F6D7EC0C3F86C0@phx.gbl обсуждение исходный текст |
| Ответ на | Re: function DECODE and triggers (Oliver Elphick <olly@lfix.co.uk>) |
| Ответы |
Re: after insert or update or delete of col2
|
| Список | 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
В списке pgsql-general по дате отправления: