boolean states

From: Jack Douglas <jack(at)douglastechnology(dot)co(dot)uk>
To: pgsql-docs(at)postgresql(dot)org
Subject: boolean states
Date: 2011-04-27 08:46:27
Message-ID: 4DB7D7E3.6010403@douglastechnology.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Ray Stell 2011-04-27 15:48:40 configuration parameter descriptions
Previous Message Josh Kupershmidt 2011-04-26 23:21:39 Re: [DOCS] 9.0.3 pdf manual is missing bookmarks