postgres.git / summary / log / commit / refs
commit 80cd99c55802d4e4517049dea341ccb356cfa3ba
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: Wed Jun 01 14:39:46 2022 +0000
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
doc/src/sgml/func.sgml | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 0713f53a2e8..9a177a4e8c8 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>
@@ -18536,7 +18536,7 @@ SELECT NULLIF(value, '(none)') ...
Is the element contained by the multirange?
</para>
<para>
- <literal>42 <@ '{[1,7)}'::int4multirange</literal>
+ <literal>4 <@ '{[1,7)}'::int4multirange</literal>
<returnvalue>t</returnvalue>
</para></entry>
</row>
[parent: f2a0060a9bfb]