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: 2005-11-25 15:25:15
Message-ID: 22310.1132932315@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-11-25 15:32:04 Re: Ipv6 and Postgresql 8.0.3
Previous Message Tom Lane 2005-11-25 15:23:41 Re: NULL safe equality operator