Re: Checking inequality - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Checking inequality
Date
Msg-id 20041211175725.GA39842@winnie.fuhr.org
Whole thread Raw
In response to Re: Checking inequality  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List 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/

pgsql-general by date:

Previous
From: Vitaly Belman
Date:
Subject: Re: Checking inequality
Next
From: Bruno Wolff III
Date:
Subject: Re: Simple function