[postgis-tickets] [SCM] PostGIS branch master updated. 3.1.0alpha1-84-g2e4e069

[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  2e4e069479c02ec2a49b1e5fb6e4ad0eeb6cbe82 (commit)
      from  430a5c3feb64ffb7dddd01a1f417a39f0bed39eb (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 2e4e069479c02ec2a49b1e5fb6e4ad0eeb6cbe82
Author: Regina Obe <lr at pcorp.us>
Date:   Mon Apr 27 18:56:14 2020 -0400

    Get rid of unneccessary CTE and also LATERAL keyword, just mention it's optional

diff --git a/doc/reference_constructor.xml b/doc/reference_constructor.xml
index 4303aa2..99dbeda 100644
--- a/doc/reference_constructor.xml
+++ b/doc/reference_constructor.xml
@@ -851,6 +851,7 @@ SELECT ST_AsText( ST_TileEnvelope(3, 1, 1, ST_MakeEnvelope(-180, -90, 180, 90, 4
 			</imageobject></inlinemediaobject></para>
 
 			<para>Availability: 3.1</para>
+			<note><para>All calls in the examples use an implicit LATERAL construct although you don't see the LATERAL keywor.  The LATERAL keyword is optional for set returning functions and is implied when using a input from prior table in the FROM.</para></note>
 
 		</refsection>
 
@@ -879,17 +880,11 @@ SELECT ST_AsText( ST_TileEnvelope(3, 1, 1, ST_MakeEnvelope(-180, -90, 180, 90, 4
 		</imageobject></inlinemediaobject></para>
 		<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
+		 <programlisting>SELECT admin1.gid, hex.geom
 	FROM admin1
-		CROSS JOIN LATERAL ST_HexagonGrid(100000, admin1.geom) AS hex
+		CROSS JOIN ST_HexagonGrid(100000, admin1.geom) AS hex
 	WHERE adm0_a3 = 'USA'
-)
-SELECT hexes.*
-FROM hexes
-	INNER JOIN admin1 ON hexes.gid = admin1.gid
-WHERE ST_Intersects(admin1.geom, hexes.geom)
-</programlisting>
+		AND ST_Intersects(admin1.geom, hex.geom)</programlisting>
 		</refsection>
 		<refsection>
 			<title>See Also</title>

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

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


hooks/post-receive
-- 
PostGIS