aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2022-06-01 10:39:46 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2022-06-01 10:39:46 -0400
commit1d0de97ba1e6ac9f76c63daee574f599df5f2f42 (patch)
treec152c0df7a566758b6b7c2aa4d39037637e24eac
parentbbb6489042a8928ccba7d72343b9ea6d0c607974 (diff)
downloadpostgresql-1d0de97ba1e6ac9f76c63daee574f599df5f2f42.tar.gz
postgresql-1d0de97ba1e6ac9f76c63daee574f599df5f2f42.zip
Doc: fix a couple of erroneous examples.
The example given for anyelement <@ anymultirange didn't return true as claimed; adjust it so it does. In passing, change a couple of sample results where the modern numeric-based logic produces a different number of trailing zeroes than before. Erik Rijkers Discussion: https://postgr.es/m/cc35735d-1ec1-5bb3-9e27-cddbab7afa23@xs4all.nl
-rw-r--r--doc/src/sgml/func.sgml6
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index db3147d1c46..478a216dbbb 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -1046,7 +1046,7 @@ repeat('Pg', 4) <returnvalue>PgPgPgPg</returnvalue>
</para>
<para>
<literal>@ -5.0</literal>
- <returnvalue>5</returnvalue>
+ <returnvalue>5.0</returnvalue>
</para></entry>
</row>
@@ -1463,7 +1463,7 @@ repeat('Pg', 4) <returnvalue>PgPgPgPg</returnvalue>
</para>
<para>
<literal>log(2.0, 64.0)</literal>
- <returnvalue>6.0000000000</returnvalue>
+ <returnvalue>6.0000000000000000</returnvalue>
</para></entry>
</row>
@@ -19876,7 +19876,7 @@ SELECT NULLIF(value, '(none)') ...
Is the element contained by the multirange?
</para>
<para>
- <literal>42 &lt;@ '{[1,7)}'::int4multirange</literal>
+ <literal>4 &lt;@ '{[1,7)}'::int4multirange</literal>
<returnvalue>t</returnvalue>
</para></entry>
</row>