diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2003-08-04 14:00:14 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2003-08-04 14:00:14 +0000 |
| commit | 3766e99c418d6211254acd580fa9d388ea4af2dd (patch) | |
| tree | ff96b080d5f669aa06b52bc9500ea10ae6ece350 /doc/src | |
| parent | 4c3c8c048d64791e71fa8f8f2a7a6de249984474 (diff) | |
Add a note that AND and OR are commutative. Apparently, they are not in
certain other products.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 10 | ||||
| -rw-r--r-- | 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> |