On Mon, Feb 23, 2009 at 9:39 AM, SHARMILA JOTHIRAJAH <sharmi_jo@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
