summaryrefslogtreecommitdiff
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:52 -0400
commit8344979d5bbc63aa8fb8c804bd933c887a2abb58 (patch)
treed50d684fb37efcb8f7782d52ea470246bf67b854
parent0b5dc1f171c4c7433cff2949d7bf64aa912765b3 (diff)
downloadpostgresql-8344979d5bbc63aa8fb8c804bd933c887a2abb58.tar.gz
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 5dea1aa986..32328de46d 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -1007,16 +1007,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>