postgres.git / summary / log / commit / refs

commit    3766e99c418d6211254acd580fa9d388ea4af2dd
Author:   Peter Eisentraut <peter_e@gmx.net>
Date:     Mon Aug 04 14:00:14 2003 +0000
First released in: 7.4

    Add a note that AND and OR are commutative.  Apparently, they are not in
    certain other products.


 doc/src/sgml/func.sgml   | 10 +++++++++-
 doc/src/sgml/syntax.sgml |  4 ++--
 2 files changed, 11 insertions(+), 3 deletions(-)

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 59d308913c3..f06f289d2d9 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.163 2003/07/31 22:17:11 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.164 2003/08/04 14:00:13 petere Exp $
 PostgreSQL documentation
 -->
 
@@ -162,6 +162,14 @@ PostgreSQL documentation
      </tgroup>
     </informaltable>
    </para>
+
+   <para>
+    The operators <literal>AND</literal> and <literal>OR</literal> are
+    commutative, that is, you can switch the left and right operand
+    without affecting the result.  But see <xref
+    linkend="syntax-express-eval"> for more information about the
+    order of evaluation of subexpressions.
+   </para>
   </sect1>
 
   <sect1 id="functions-comparison">
diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml
index 372aca2ca71..8d23a3e3548 100644
--- a/doc/src/sgml/syntax.sgml
+++ b/doc/src/sgml/syntax.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/syntax.sgml,v 1.79 2003/06/19 23:22:40 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/syntax.sgml,v 1.80 2003/08/04 14:00:14 petere Exp $
 -->
 
 <chapter id="sql-syntax">
@@ -1216,7 +1216,7 @@ SELECT name, (SELECT max(pop) FROM cities WHERE cities.state = states.name)
    </para>
   </sect2>
 
-  <sect2>
+  <sect2 id="syntax-express-eval">
    <title>Expression Evaluation</title>
 
    <para>


[parent: 4c3c8c048d64]