summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPeter Eisentraut <peter_e@gmx.net>2010-07-24 12:17:34 +0000
committerPeter Eisentraut <peter_e@gmx.net>2010-07-24 12:17:34 +0000
commit730fba4bc8fca784b6e078e5120ff551b6c55490 (patch)
treee9c0e1f238f0bb96360ae77b785b6ac46a800a64
parent3d903da124e5d121fd1f571cdb0021a357bbe4d6 (diff)
Tidy up boolean data type page
by Thom Brown
-rw-r--r--doc/src/sgml/datatype.sgml43
1 files changed, 30 insertions, 13 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
index 20bf2ea9fa2..fa365a4149b 100644
--- a/doc/src/sgml/datatype.sgml
+++ b/doc/src/sgml/datatype.sgml
@@ -1,4 +1,4 @@
-<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.250 2010/07/03 04:03:06 tgl Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.250.2.1 2010/07/24 12:17:34 petere Exp $ -->
<chapter id="datatype">
<title>Data Types</title>
@@ -2751,13 +2751,34 @@ P <optional> <replaceable>years</>-<replaceable>months</>-<replaceable>days</> <
<para>
<productname>PostgreSQL</productname> provides the
- standard <acronym>SQL</acronym> type <type>boolean</type>.
- <type>boolean</type> can have one of only two states:
+ standard <acronym>SQL</acronym> type <type>boolean</type>;
+ see <xref linkend="datatype-boolean-table">.
+ The <type>boolean</type> type can have one of only two states:
<quote>true</quote> or <quote>false</quote>. A third state,
<quote>unknown</quote>, is represented by the
<acronym>SQL</acronym> null value.
</para>
+ <table id="datatype-boolean-table">
+ <title>Boolean Data Type</title>
+ <tgroup cols="3">
+ <thead>
+ <row>
+ <entry>Name</entry>
+ <entry>Storage Size</entry>
+ <entry>Description</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry><type>boolean</type></entry>
+ <entry>1 byte</entry>
+ <entry>state of true of false</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </table>
+
<para>
Valid literal values for the <quote>true</quote> state are:
<simplelist>
@@ -2786,6 +2807,12 @@ P <optional> <replaceable>years</>-<replaceable>months</>-<replaceable>days</> <
(<acronym>SQL</acronym>-compliant) usage.
</para>
+ <para>
+ <xref linkend="datatype-boolean-example"> shows that
+ <type>boolean</type> values are output using the letters
+ <literal>t</literal> and <literal>f</literal>.
+ </para>
+
<example id="datatype-boolean-example">
<title>Using the <type>boolean</type> type</title>
@@ -2805,16 +2832,6 @@ SELECT * FROM test1 WHERE a;
t | sic est
</programlisting>
</example>
-
- <para>
- <xref linkend="datatype-boolean-example"> shows that
- <type>boolean</type> values are output using the letters
- <literal>t</literal> and <literal>f</literal>.
- </para>
-
- <para>
- <type>boolean</type> uses 1 byte of storage.
- </para>
</sect1>
<sect1 id="datatype-enum">