Re: Type conversions and nulls - Mailing list pgsql-general

From Tom Lane
Subject Re: Type conversions and nulls
Date
Msg-id 19329.1084331756@sss.pgh.pa.us
Whole thread Raw
In response to Re: Type conversions and nulls  (Edmund Dengler <edmundd@eSentire.com>)
List pgsql-general
Edmund Dengler <edmundd@eSentire.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

pgsql-general by date:

Previous
From: Rachel McConnell
Date:
Subject: Re: template1, createdb, schemas, and owners
Next
From: Daniel Fitzgerald
Date:
Subject: Need a hardware optimization pointer