NOTIFY QUESTION - Mailing list pgsql-general

From Oisin Glynn
Subject NOTIFY QUESTION
Date
Msg-id 45ABC1F4.6040700@oisinglynn.com
Whole thread Raw
Responses Re: NOTIFY QUESTION  (Oisin Glynn <me@oisinglynn.com>)
List pgsql-general
From the Docs see below it implies that the WHERE clause of the update
is ignored.(
http://www.postgresql.org/docs/8.1/static/sql-createrule.html )
If I create a Rule as

CREATE RULE foo_update_false AS ON UPDATE TO foo
   WHERE NEW.some_flag = TRUE
   DO NOTIFY foo_update;


Does the WHERE clause in the rule get ignored as well?  If so Could I
create a regular trigger and do the notification from within the trigger
having put a check in the  trigger?

Thanks,

Oisin





pgsql-general by date:

Previous
From: "Ardian Xharra"
Date:
Subject: Re: Why the data changes it's value by itself!
Next
From: Aleksander Kmetec
Date:
Subject: Re: Unpredicatable behavior of volatile functions used