On Mon, Feb 23, 2009 at 9:39 AM, SHARMILA JOTHIRAJAH
<sharmi...@yahoo.com> wrote:

>    IF ( newValue != oldValue)

One good piece of advice that Tom Lane pointed out to me was:

IF ( newValue IS DISTINCT FROM oldValue )

is better due to (what may be) the unexpected results of equality
testing when NULL values are thrown into the mix.


-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to