Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 9EC361337B69 for ; Tue, 10 May 2011 00:24:23 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 41856-05 for ; Tue, 10 May 2011 03:24:04 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from momjian.us (momjian.us [70.90.9.53]) by mail.postgresql.org (Postfix) with ESMTP id 58C2C133740B for ; Tue, 10 May 2011 00:24:03 -0300 (ADT) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id p4A3O0312665; Mon, 9 May 2011 23:24:00 -0400 (EDT) From: Bruce Momjian Message-Id: <201105100324.p4A3O0312665@momjian.us> Subject: Re: boolean states In-Reply-To: To: Josh Kupershmidt Date: Mon, 9 May 2011 23:24:00 -0400 (EDT) CC: Kevin Grittner , jaime@2ndquadrant.com, jack@douglastechnology.co.uk, pgsql-docs@postgresql.org X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="ELM1304997840-4194-2_" Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201105/43 X-Sequence-Number: 6718 --ELM1304997840-4194-2_ Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" Josh Kupershmidt wrote: > On Mon, May 9, 2011 at 9:04 PM, Bruce Momjian wrote: > > Attached patch applied to HEAD and 9.0.X. > > The patch you attached looks like it's a fix for the -bugs thread > about "inappropriate reference to boolean logic", not the complaint > raised in this thread. I see what you mean. I have applied the attached doc patch to HEAD. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + --ELM1304997840-4194-2_ Content-Transfer-Encoding: 7bit Content-Type: text/x-diff Content-Disposition: inline; filename="/rtmp/diff" diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml new file mode 100644 index bc1ec3f..ab8eb2d *** a/doc/src/sgml/datatype.sgml --- b/doc/src/sgml/datatype.sgml *************** P years-PostgreSQL provides the standard SQL type boolean; see . ! The boolean type can have one of only two states: ! true or false. A third state, ! unknown, is represented by the SQL null value. --- 2784,2792 ---- PostgreSQL provides the standard SQL type boolean; see . ! The boolean type can have several states: ! true, false, and a third state, ! unknown, which is represented by the SQL null value. --ELM1304997840-4194-2_--