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
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"