summaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorNeil Conway <neilc@samurai.com>2007-06-01 23:40:19 +0000
committerNeil Conway <neilc@samurai.com>2007-06-01 23:40:19 +0000
commitf086be3d39ce003532ce818347354fe8d6efe8eb (patch)
tree5e1c727cf92b4c410b2a75a54663acf6a5bb90cf /doc/src
parentbd0a260928971feec484a22f0b86e5d1936c974f (diff)
Allow leading and trailing whitespace in the input to the boolean
type. Also, add explicit casts between boolean and text/varchar. Both of these changes are for conformance with SQL:2003. Update the regression tests, bump the catversion.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/datatype.sgml8
1 files changed, 4 insertions, 4 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
index 17357d84088..3802aa24dff 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.202 2007/05/29 04:58:43 neilc Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.203 2007/06/01 23:40:18 neilc Exp $ -->
<chapter id="datatype">
<title id="datatype-title">Data Types</title>
@@ -2403,9 +2403,9 @@ January 8 04:05:06 1999 PST
<member><literal>'no'</literal></member>
<member><literal>'0'</literal></member>
</simplelist>
- Using the key words <literal>TRUE</literal> and
- <literal>FALSE</literal> is preferred (and
- <acronym>SQL</acronym>-compliant).
+ Leading and trailing whitespace is ignored. Using the key words
+ <literal>TRUE</literal> and <literal>FALSE</literal> is preferred
+ (and <acronym>SQL</acronym>-compliant).
</para>
<example id="datatype-boolean-example">