Re: Checking inequality - Mailing list pgsql-general

From Vitaly Belman
Subject Re: Checking inequality
Date
Msg-id fa96e3c604121109594e56dd33@mail.gmail.com
Whole thread Raw
In response to Checking inequality  (Vitaly Belman <vitalyb@gmail.com>)
List pgsql-general
True. It does seem more proper.
Thanks.


On Sat, 11 Dec 2004 10:57:25 -0700, Michael Fuhr <mike@fuhr.org> wrote:
> 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/
>


--
 ICQ: 1912453
 AIM: VitalyB1984
 MSN: tmdagent@hotmail.com
 Yahoo!: VitalyBe

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sql performace - why soo long ?
Next
From: Michael Fuhr
Date:
Subject: Re: Checking inequality