Postgres Pro
Downloads
Home   >   mailing lists

Re: Rule Question - Mailing list pgsql-general

From bricklen
Subject Re: Rule Question
Date
Msg-id CAGrpgQ88rsusupvW7UhKXsqwfKbBz566kbd8Uny0vH5MixMsZg@mail.gmail.com
Whole thread Raw
In response to Re: Rule Question  (Giuseppe Broccolo <giuseppe.broccolo@2ndquadrant.it>)
Responses Re: Rule Question  (Giuseppe Broccolo <giuseppe.broccolo@2ndquadrant.it>)
List pgsql-general
Tree view

On Thu, Jul 25, 2013 at 4:18 AM, Giuseppe Broccolo <giuseppe.broccolo@2ndquadrant.it> wrote:
            (TG_OP = 'UPDATE' AND
                (NEW.b != OLD.b OR
                    (NEW.b IS NULL AND OLD.b IS NOT NULL) OR
                    (NEW.b IS NOT NULL AND OLD.b IS NULL)
                )
        ) THEN



Unrelated to the OP's question, the suggestion above could be more simply rewritten as

TG_OP = 'UPDATE'
AND NEW.b IS DISTINCT FROM OLD.b

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: group by query plan on already clustered index
Next
From: "Gauthier, Dave"
Date:
Subject: Re: Why are stored procedures looked on so negatively?