Postgres Pro
Downloads
Home   >   mailing lists

Re: How to notice column changes in trigger - Mailing list pgsql-performance

From Andreas Pflug
Subject Re: How to notice column changes in trigger
Date
Msg-id 3E6772C4.5010005@web.de
Whole thread Raw
In response to Re: How to notice column changes in trigger  (Oliver Elphick <olly@lfix.co.uk>)
Responses Re: How to notice column changes in trigger
List pgsql-performance
Tree view 
Oliver Elphick wrote:

>  IF NEW.b = OLD.b OR (NEW.b IS NULL AND OLD.b IS NULL) THEN
>    -- b has not changed
>    ...
>  END IF;
>
>
This doesn't cover case 3, since UPDATE ... SET b=b will lead to NEW.b=OLD.b

pgsql-performance by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: How to notice column changes in trigger
Next
From: Josh Berkus
Date:
Subject: Re: How to notice column changes in trigger