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: Fri, 25 Nov 2005 06:50:25 +0100 (CET)
- Message-id: <Pine(dot)LNX(dot)4(dot)44(dot)0511250648580(dot)25251-100000(at)zigo(dot)dhs(dot)org>
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
Home |
Main Index |
Thread Index