Notify rule - Mailing list pgsql-general

From ivan_14_32
Subject Notify rule
Date
Msg-id 4D635FC8.20304@mail.ru
Whole thread Raw
Responses Re: Notify rule  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Notify rule  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
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" as text)
too.

Q: How can I send tuple id (integer primary key) via notify using Rule?
    Target is erasing deprecated tuples from application's cache.

pgsql-general by date:

Previous
From: Joel Reed
Date:
Subject: string_agg hanging?
Next
From: Pavel Stehule
Date:
Subject: Re: string_agg hanging?