Postgres Pro
Downloads
Home   >   mailing lists

Re: Difference between "foo is false" and "foo=false"? Partial index on boolean. - Mailing list pgsql-sql

From Tom Lane
Subject Re: Difference between "foo is false" and "foo=false"? Partial index on boolean.
Date
Msg-id 14040.1188881806@sss.pgh.pa.us
Whole thread Raw
In response to Difference between "foo is false" and "foo=false"? Partial index on boolean.  (Bryce Nesbitt <bryce1@obviously.com>)
Responses Re: Difference between "foo is false" and "foo=false"? Partial index on boolean.
List pgsql-sql
Tree view 
Bryce Nesbitt <bryce1@obviously.com> writes:
> Could someone explain
> the difference between "foo=false" and "foo is false", for a boolean
> type column?

They give different results for NULL --- specifically, NULL for the
former and FALSE for the latter.  Don't blame me, it's in the spec...
        regards, tom lane

pgsql-sql by date:

Previous
From: Bryce Nesbitt
Date:
Subject: Difference between "foo is false" and "foo=false"? Partial index on boolean.
Next
From: Bryce Nesbitt
Date:
Subject: Re: Difference between "foo is false" and "foo=false"? Partial index on boolean.