Thread: NOTIFY QUESTION

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

Oisin Glynn wrote:
>> 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
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
This had to be done with a trigger.

Oisin