NOTIFY QUESTION

From: Oisin Glynn <me(at)oisinglynn(dot)com>
To: postgreSQL postgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: NOTIFY QUESTION
Date: 2007-01-15 18:03:32
Message-ID: 45ABC1F4.6040700@oisinglynn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2007-01-15 18:07:29 Re: [HACKERS] Checkpoint request failed on version 8.2.1.
Previous Message Aleksander Kmetec 2007-01-15 18:03:28 Re: Unpredicatable behavior of volatile functions used