aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2021-07-21 18:03:33 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2021-07-21 18:03:45 -0400
commit227c4e57d6a70961e015ed4185facfc638afd048 (patch)
tree9292ad5b9fa50dc8ebf7da8300bc3b9a116baa5a
parent65cc77c9847022f895a12012085606d8553c5fff (diff)
downloadpostgresql-227c4e57d6a70961e015ed4185facfc638afd048.tar.gz
postgresql-227c4e57d6a70961e015ed4185facfc638afd048.zip
Doc: improve documentation about exponentiation operator.
Now that we're not having to wedge this into the straitjacket of the old operator table format, we can add another example to clarify the point about left-to-right associativity. Per suggestion from mdione at grulic.org.ar. https://postgr.es/m/162661954599.693.13700316547731859171@wrigleys.postgresql.org
-rw-r--r--doc/src/sgml/func.sgml11
1 files changed, 9 insertions, 2 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index e833be8f96b..f62c33e5c71 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -988,16 +988,23 @@ repeat('Pg', 4) <returnvalue>PgPgPgPg</returnvalue>
<returnvalue>double precision</returnvalue>
</para>
<para>
- Exponentiation (unlike typical mathematical practice, multiple uses of
- <literal>^</literal> will associate left to right)
+ Exponentiation
</para>
<para>
<literal>2 ^ 3</literal>
<returnvalue>8</returnvalue>
</para>
<para>
+ Unlike typical mathematical practice, multiple uses of
+ <literal>^</literal> will associate left to right by default:
+ </para>
+ <para>
<literal>2 ^ 3 ^ 3</literal>
<returnvalue>512</returnvalue>
+ </para>
+ <para>
+ <literal>2 ^ (3 ^ 3)</literal>
+ <returnvalue>134217728</returnvalue>
</para></entry>
</row>