Re: [GENERAL] "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records)

2011-08-24 Thread ivan_14_32
01.05.2011 12:58, Basil Bourque wrote: Hoorah! I was able to complete my single PL/pgSQL function to create history records tracking individual field value changes generically for all my tables. Some developers call this an "audit trail", though an accountant might say otherwise. I made auditi

[GENERAL] Notify rule

2011-02-21 Thread ivan_14_32
Hi! I trying to create rule for update notifing: CREATE OR REPLACE RULE "ttt_NotifyU" AS ON UPDATE TO "ttt" DO NOTIFY "ttt", '88'; this work. But this CREATE OR REPLACE RULE "ttt_NotifyU" AS ON UPDATE TO "ttt" DO NOTIFY "ttt", NEW."id"; don't (syntax error), NOTIFY "ttt", CAST(NEW."id"