Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group