On Thu, Sep 9, 2010 at 10:48 AM, Rob Richardson
<Rob(dot)Richardson(at)rad-con(dot)com> wrote:
>
> If old.value <> new.value then
> do something
> End if
If old.value IS DISTINCT FROM new.value THEN
--do something
End if
This version will produce expected results when dealing with nulls. I
learned this the hard way.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug