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: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
  • To: Peter Eisentraut <peter_e(at)gmx(dot)net>
  • Cc: pgsql-hackers(at)postgresql(dot)org, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Michael Glaesemann <grzm(at)myrealbox(dot)com>
  • Subject: Re: NULL safe equality operator
  • Date: Fri, 25 Nov 2005 10:25:15 -0500
  • Message-id: <22310(dot)1132932315(at)sss(dot)pgh(dot)pa(dot)us>
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Christopher Kings-Lynne wrote:
>> Needs to return 0 or 1 though.

> All Boolean operators in MySQL do that, so to create an illusion of 
> MySQL compatibility, you'd need to redefine all standard Boolean 
> operators.  I don't think you want that.

Wonder if making an implicit cast from bool to int would answer for
that.

			regards, tom lane
Home | Main Index | Thread Index

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