Postgres Pro
Downloads
Home   >   mailing lists

Re: BOOLEAN data type? - Mailing list pgsql-sql

From Tom Lane
Subject Re: BOOLEAN data type?
Date
Msg-id 15042.987273120@sss.pgh.pa.us
Whole thread Raw
In response to BOOLEAN data type?  ("Josh Berkus" <josh@agliodbs.com>)
Responses Re: BOOLEAN data type?  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
Tree view 
"Josh Berkus" <josh@agliodbs.com> writes:
> Can someone explain this to me?

Are you taking into account that SQL booleans are actually three-valued?
They can be TRUE, FALSE, or NULL (NULL taken as meaning "don't know").
        regards, tom lane

pgsql-sql by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: Dropping users with no name
Next
From: Cedar Cox
Date:
Subject: Re: Bug in user management?