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