[postgis-tickets] [SCM] PostGIS branch master updated. 3.3.0rc2-337-gc7c9e2225
git at osgeo.org
git at osgeo.org
Mon Nov 14 17:26:26 PST 2022
This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".
The branch, master has been updated
via c7c9e22255696e1461aeeb96b424ff2e22b45468 (commit)
via 996970f6d0d01be6ad7fa4673ecb6c71c91dacdc (commit)
from ae95dd219b2db85289452ca5725d87df32320d3c (commit)
Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.
- Log -----------------------------------------------------------------
commit c7c9e22255696e1461aeeb96b424ff2e22b45468
Author: Hannes <kannes at users.noreply.github.com>
Date: Tue Nov 1 20:28:16 2022 +0100
Include example of ST_Disjoint = NOT ST_Intersects
diff --git a/doc/reference_relationship.xml b/doc/reference_relationship.xml
index bd033cf30..19915df6b 100644
--- a/doc/reference_relationship.xml
+++ b/doc/reference_relationship.xml
@@ -794,7 +794,8 @@ WHERE ST_Crosses(roads.geom, highways.geom);</programlisting>
<para>Performed by the GEOS module</para>
<note>
<para>This function call does not use indexes. A negated <xref linkend="ST_Intersects" /> predicate
- can be used as a more performant alternative that uses indexes.</para>
+ can be used as a more performant alternative that uses indexes:
+ <code>ST_Disjoint(A,B) = NOT ST_Intersects(A,B)</code></para>
</note>
<note>
commit 996970f6d0d01be6ad7fa4673ecb6c71c91dacdc
Author: Hannes <kannes at users.noreply.github.com>
Date: Mon Oct 31 20:10:37 2022 +0100
Mention "NOT ST_Intersects" as index-using alternative to ST_Disjoint
Ref https://twitter.com/cartocalypse/status/1585223073418350593
diff --git a/doc/reference_relationship.xml b/doc/reference_relationship.xml
index 97fcc3ba3..bd033cf30 100644
--- a/doc/reference_relationship.xml
+++ b/doc/reference_relationship.xml
@@ -793,7 +793,8 @@ WHERE ST_Crosses(roads.geom, highways.geom);</programlisting>
<para>Performed by the GEOS module</para>
<note>
- <para>This function call does not use indexes</para>
+ <para>This function call does not use indexes. A negated <xref linkend="ST_Intersects" /> predicate
+ can be used as a more performant alternative that uses indexes.</para>
</note>
<note>
-----------------------------------------------------------------------
Summary of changes:
doc/reference_relationship.xml | 4 +++-
1 file changed, 3 insertions(+), 1 deletion(-)
hooks/post-receive
--
PostGIS
More information about the postgis-tickets
mailing list