public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bruce Momjian <[email protected]>
To: Kevin Grittner <[email protected]>
Cc: [email protected]
Cc: [email protected]
Cc: [email protected]
Subject: Re: boolean states
Date: Mon, 9 May 2011 21:04:49 -0400 (EDT)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
Kevin Grittner wrote:
> Jack Douglas wrote:
>
> > There are two kinds of people on this earth, those who understand
> > boolean arithmatic and those who don't. I'm not one of them.
>
> Hmmm... From that, I don't know if you do. Which do I record in the
> understands_boolean column of the database record for you? Dang, I
> knew I should have had *two* flags: known_to_understand_boolean and
> known_to_not_understand_boolean. That would have been much simpler
> than allowing NULL for UNKNOWN....
Attached patch applied to HEAD and 9.0.X.
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
Attachments:
[text/x-diff] /rtmp/diff (788B, 2-%2Frtmp%2Fdiff)
download | inline diff:
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
new file mode 100644
index 657835c..c1a34fb
*** a/doc/src/sgml/func.sgml
--- b/doc/src/sgml/func.sgml
***************
*** 82,89 ****
<member><literal>NOT</></member>
</simplelist>
! <acronym>SQL</acronym> uses a three-valued Boolean logic where the null value represents
! <quote>unknown</quote>. Observe the following truth tables:
<informaltable>
<tgroup cols="4">
--- 82,90 ----
<member><literal>NOT</></member>
</simplelist>
! <acronym>SQL</acronym> uses a three-valued logic system with true,
! false, and <literal>null</>, which represents <quote>unknown</quote>.
! Observe the following truth tables:
<informaltable>
<tgroup cols="4">
view thread (10+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: boolean states
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox