[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