postgres.git / summary / log / commit / refs
commit fbf99d2f16a82f13564bbd21689d018ecc72de01
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date: Tue Nov 08 07:40:37 2011 +0000
First released in: 9.2.0
Adjust range type docs for some last-minute changes I made to the patch.
non_empty(anyrange) function was removed, empty(anyrange) was renamed to
isempty(anyrange), and !? operators were removed.
doc/src/sgml/func.sgml | 33 +++------------------------------
doc/src/sgml/rangetypes.sgml | 2 +-
2 files changed, 4 insertions(+), 31 deletions(-)
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index f81bb9db977..7ecf7510435 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -10596,19 +10596,6 @@ SELECT NULLIF(value, '(none)') ...
<entry><literal>[10,15)</literal></entry>
</row>
- <row>
- <entry> <literal>!?</literal> </entry>
- <entry>Is empty?</entry>
- <entry><literal>'empty'::int4range !?</literal></entry>
- <entry><literal>t</literal></entry>
- </row>
-
- <row>
- <entry> <literal>?</literal> </entry>
- <entry>Is non-empty?</entry>
- <entry><literal>numrange(1.0,2.0)?</literal></entry>
- <entry><literal>t</literal></entry>
- </row>
</tbody>
</tgroup>
</table>
@@ -10637,10 +10624,7 @@ SELECT NULLIF(value, '(none)') ...
<primary>upper</primary>
</indexterm>
<indexterm>
- <primary>empty</primary>
- </indexterm>
- <indexterm>
- <primary>non_empty</primary>
+ <primary>isempty</primary>
</indexterm>
<indexterm>
<primary>lower_inc</primary>
@@ -10693,25 +10677,14 @@ SELECT NULLIF(value, '(none)') ...
<row>
<entry>
<literal>
- <function>empty</function>(<type>anyrange</type>)
+ <function>isempty</function>(<type>anyrange</type>)
</literal>
</entry>
<entry><type>anyrange</type></entry>
<entry>is the range empty?</entry>
- <entry><literal>empty(numrange(1.1,2.2))</literal></entry>
+ <entry><literal>isempty(numrange(1.1,2.2))</literal></entry>
<entry><literal>false</literal></entry>
</row>
- <row>
- <entry>
- <literal>
- <function>non_empty</function>(<type>anyrange</type>)
- </literal>
- </entry>
- <entry><type>anyrange</type></entry>
- <entry>is the range non-empty?</entry>
- <entry><literal>non_empty(numrange(1.1,2.2))</literal></entry>
- <entry><literal>true</literal></entry>
- </row>
<row>
<entry>
<literal>
diff --git a/doc/src/sgml/rangetypes.sgml b/doc/src/sgml/rangetypes.sgml
index fc5896d8f42..cf16f25de91 100644
--- a/doc/src/sgml/rangetypes.sgml
+++ b/doc/src/sgml/rangetypes.sgml
@@ -84,7 +84,7 @@ SELECT upper(int8range(15, 25));
SELECT int4range(10, 20) * int4range(15, 25);
-- Is the range non-empty?
-SELECT numrange(1, 5)? ;
+SELECT isempty(numrange(1, 5));
</programlisting>
[parent: 6477d66780df]