Re: Type conversions and nulls

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Edmund Dengler <edmundd(at)eSentire(dot)com>
Cc: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Type conversions and nulls
Date: 2004-05-12 03:15:56
Message-ID: 19329.1084331756@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Edmund Dengler <edmundd(at)eSentire(dot)com> writes:
> What I want is an '=' that compares nulls as equal (rather than as
> not-equal, which is the normal case).

IS DISTINCT FROM may help you here. It's a not-equals operator rather
than an equals operator, but it does what you want.

(Unless what you wanted included being able to use an index...)

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Fitzgerald 2004-05-12 03:27:03 Need a hardware optimization pointer
Previous Message Rachel McConnell 2004-05-12 01:48:15 Re: template1, createdb, schemas, and owners