Postgres Pro
Downloads
Home   >   mailing lists

Re: NULL safe equality operator - Mailing list pgsql-hackers

From Tom Lane
Subject Re: NULL safe equality operator
Date
Msg-id 17483.1132886951@sss.pgh.pa.us
Whole thread Raw
In response to NULL safe equality operator  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: NULL safe equality operator  (Dennis Bjorklund <db@zigo.dhs.org>)
List pgsql-hackers
Tree view 
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> Does anyone know how I'd go about implementing the following MySQL 
> operator in PostgreSQL?

NOT (x IS DISTINCT FROM y) would be the standard-compliant way of
spelling that.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: NULL safe equality operator
Next
From: Greg Stark
Date:
Subject: Re: gprof SELECT COUNT(*) results