boolean states - Mailing list pgsql-docs

From Jack Douglas
Subject boolean states
Date
Msg-id 4DB7D7E3.6010403@douglastechnology.co.uk
Whole thread Raw
Responses Re: boolean states  (Josh Kupershmidt <schmiddy@gmail.com>)
Re: boolean states  (Jaime Casanova <jaime@2ndquadrant.com>)
List pgsql-docs
Hi

http://www.postgresql.org/docs/current/static/datatype-boolean.html states:

         The boolean type can have one of only two states: "true" or
"false". A third state, "unknown", is represented by the SQL null value.

This sounds like an oxymoron to me. Perhaps that sentence should be
changed to:

         The boolean type can have one of three states: "true" or
"false" and "unknown". The third state, "unknown", is represented by the
SQL null value.
or:

         The boolean type can have one of three states: "true" or
"false" and null. The third state, null, represents the logical value
"unknown".

Best regards
Jack Douglas


pgsql-docs by date:

Previous
From: Josh Kupershmidt
Date:
Subject: Re: [pgsql-www] 9.0.3 pdf manual is missing bookmarks
Next
From: Ray Stell
Date:
Subject: configuration parameter descriptions