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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group