[postgis-tickets] [SCM] PostGIS branch master updated. 3.1.0alpha1-83-g430a5c3

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

The branch, master has been updated
       via  430a5c3feb64ffb7dddd01a1f417a39f0bed39eb (commit)
      from  d178fcfa46d1e1ff7039cdd2231ae63f37b2385f (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 430a5c3feb64ffb7dddd01a1f417a39f0bed39eb
Author: Regina Obe <lr at pcorp.us>
Date:   Mon Apr 27 18:38:48 2020 -0400

    Minor formatting changes and consistent use of lateral

diff --git a/doc/reference_constructor.xml b/doc/reference_constructor.xml
index 0fe9437..4303aa2 100644
--- a/doc/reference_constructor.xml
+++ b/doc/reference_constructor.xml
@@ -859,13 +859,13 @@ SELECT ST_AsText( ST_TileEnvelope(3, 1, 1, ST_MakeEnvelope(-180, -90, 180, 90, 4
 		<para>To do a point summary against a hexagonal tiling, generate a hexagon grid using the
 		extent of the points as the bounds, then spatially join to that grid.</para>
 		 <programlisting>WITH bounds AS (
- 	SELECT ST_SetSRID(ST_EstimatedExtent('pointtable', 'geom'),3857) AS geom
+ 		SELECT ST_SetSRID(ST_EstimatedExtent('pointtable', 'geom'),3857) AS geom
  )
- SELECT Count(*), hexes.geom
- FROM bounds CROSS JOIN
- 	LATERAL ST_HexagonGrid(10000, bounds.geom) AS hexes
- INNER JOIN  pointtable AS pts
- 	ON ST_Intersects(pts.geom, hexes.geom)
+ SELECT COUNT(*), hexes.geom
+ FROM bounds
+ 	CROSS JOIN
+ 		LATERAL ST_HexagonGrid(10000, bounds.geom) AS hexes
+	INNER JOIN pointtable AS pts ON ST_Intersects(pts.geom, hexes.geom)
  GROUP BY hexes.geom;</programlisting>
 		</refsection>
 
@@ -880,14 +880,14 @@ SELECT ST_AsText( ST_TileEnvelope(3, 1, 1, ST_MakeEnvelope(-180, -90, 180, 90, 4
 		<para>Tiling states results in a hexagon coverage of each state, and multiple
 			hexagons overlapping at the borders between states.</para>
 		 <programlisting>WITH hexes AS (
-	SELECT admin1.gid,
-	      hex.geom
-	FROM admin1 CROSS JOIN ST_HexagonGrid(100000, admin1.geom) AS hex
+	SELECT admin1.gid, hex.geom
+	FROM admin1
+		CROSS JOIN LATERAL ST_HexagonGrid(100000, admin1.geom) AS hex
 	WHERE adm0_a3 = 'USA'
 )
 SELECT hexes.*
 FROM hexes
-INNER JOIN admin1 ON hexes.gid = admin1.gid
+	INNER JOIN admin1 ON hexes.gid = admin1.gid
 WHERE ST_Intersects(admin1.geom, hexes.geom)
 </programlisting>
 		</refsection>

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

Summary of changes:
 doc/reference_constructor.xml | 20 ++++++++++----------
 1 file changed, 10 insertions(+), 10 deletions(-)


hooks/post-receive
-- 
PostGIS