[postgis-tickets] [SCM] postgis.net branch website updated. clarity-final-18-gc99bd2d

[git at osgeo.org]

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.net".

The branch, website has been updated
       via  c99bd2d97949b02421b11e543dcad14f5b4041fb (commit)
      from  0c3892672c0d334ba420bd9703e40b7f06f8f04f (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 c99bd2d97949b02421b11e543dcad14f5b4041fb
Author: Paul Ramsey <pramsey at cleverelephant.ca>
Date:   Thu May 18 10:50:03 2023 -0700

    add example

diff --git a/content/documentation/faq/spatial-indexes.md b/content/documentation/faq/spatial-indexes.md
index a0ae1b2..b088255 100644
--- a/content/documentation/faq/spatial-indexes.md
+++ b/content/documentation/faq/spatial-indexes.md
@@ -40,7 +40,15 @@ There are a limited set of functions that can make use of a spatial index as a p
 * [ST_OrderingEquals](/docs/ST_OrderingEquals.html)
 * [ST_Equals](/docs/ST_Equals.html)
 
-So a spatial join query can make use of a spatial relationship between tables and get index acceleration like this:
+So a spatial join query can make use of a spatial relationship function and get index acceleration like this:
+
+```postgres
+SELECT a.*
+FROM a
+WHERE ST_Intersects(a.geom, ST_Point(-126, 45, 4326))
+```
+
+And can use a spatial relationship to drive a join, like this:
 
 ```postgres
 SELECT a.name, b.id

-----------------------------------------------------------------------

Summary of changes:
 content/documentation/faq/spatial-indexes.md | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)


hooks/post-receive
-- 
postgis.net