Re: Checking inequality

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: Vitaly Belman <vitalyb(at)gmail(dot)com>, PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Checking inequality
Date: 2004-12-11 17:57:25
Message-ID: 20041211175725.GA39842@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Dec 11, 2004 at 08:54:40AM -0800, Stephan Szabo wrote:

> old.series_id IS DISTINCT FROM new.series_id may do what you want
> depending on how you want NULLs to compare (IS DISTINCT FROM would be
> false).

I forgot about IS DISTINCT FROM. I like that better than using
COALESCE, as I had suggested.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vitaly Belman 2004-12-11 17:59:55 Re: Checking inequality
Previous Message Tom Lane 2004-12-11 17:29:21 Re: Sql performace - why soo long ?