Postgres Pro
Downloads
Home   >   mailing lists

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

From Dennis Bjorklund
Subject Re: NULL safe equality operator
Date
Msg-id Pine.LNX.4.44.0511250648580.25251-100000@zigo.dhs.org
Whole thread Raw
In response to Re: NULL safe equality operator  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On Thu, 24 Nov 2005, Tom Lane wrote:

> NOT (x IS DISTINCT FROM y) would be the standard-compliant way of
> spelling that.

That's the sql99 way. In sql2003 (but not in pg) one can also do
 X IS NOT DISTINCT FROM y

-- 
/Dennis Björklund

pgsql-hackers by date:

Previous
From: Olivier Thauvin
Date:
Subject: Re: PL/php in pg_pltemplate
Next
From: Qingqing Zhou
Date:
Subject: Re: gprof SELECT COUNT(*) results