Re: [GENERAL] NOTIFY QUESTION

2007-01-16 Thread Oisin Glynn
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; D

[GENERAL] NOTIFY QUESTION

2007-01-15 Thread Oisin Glynn
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