Обсуждение: 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