diff options
| author | Alexander Korotkov <akorotkov@postgresql.org> | 2020-12-29 23:35:33 +0300 |
|---|---|---|
| committer | Alexander Korotkov <akorotkov@postgresql.org> | 2020-12-29 23:35:33 +0300 |
| commit | 4d7684cc754f312aee468abb83ca4f7da94b30a3 (patch) | |
| tree | 7fea580c6c30561d5a50c2a5d14b612a7b4e6626 /doc/src | |
| parent | a5b81b6f0006ea0b502780ce7f73d295a225842c (diff) | |
| download | postgresql-4d7684cc754f312aee468abb83ca4f7da94b30a3.tar.gz postgresql-4d7684cc754f312aee468abb83ca4f7da94b30a3.zip | |
Implement operators for checking if the range contains a multirange
We have operators for checking if the multirange contains a range but don't
have the opposite. This commit improves completeness of the operator set by
adding two new operators: @> (anyrange,anymultirange) and
<@(anymultirange,anyrange).
Catversion is bumped.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 93d17e4b558..5021ac1ca96 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -18184,6 +18184,20 @@ SELECT NULLIF(value, '(none)') ... <row> <entry role="func_table_entry"><para role="func_signature"> + <type>anyrange</type> <literal>@></literal> <type>anymultirange</type> + <returnvalue>boolean</returnvalue> + </para> + <para> + Does the range contain the multirange? + </para> + <para> + <literal>'[2,4)'::int4range @> '{[2,3)}'::int4multirange</literal> + <returnvalue>t</returnvalue> + </para></entry> + </row> + + <row> + <entry role="func_table_entry"><para role="func_signature"> <type>anymultirange</type> <literal><@</literal> <type>anymultirange</type> <returnvalue>boolean</returnvalue> </para> |