On Mon, Feb 23, 2009 at 9:39 AM, SHARMILA JOTHIRAJAH
<sharmi_jo@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