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 по дате отправления: