Re: NULL safe equality operator

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: NULL safe equality operator
Date: 2005-11-25 05:50:25
Message-ID: Pine.LNX.4.44.0511250648580.25251-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Qingqing Zhou 2005-11-25 05:58:23 Re: gprof SELECT COUNT(*) results
Previous Message Olivier Thauvin 2005-11-25 05:11:21 Re: PL/php in pg_pltemplate