[postgis-tickets] [SCM] PostGIS branch master updated. 3.3.0rc2-1114-g92a3500f6

[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  92a3500f67498ce328d73c0a8456928257d63859 (commit)
      from  9b9a99dd0302f3a4e0b8a1c628fd00ba6f0e348d (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 92a3500f67498ce328d73c0a8456928257d63859
Author: Martin Davis <mtnclimb at gmail.com>
Date:   Tue Jul 4 07:11:24 2023 -0700

    Improve doc ST_CoverageSimplify example

diff --git a/doc/reference_coverage.xml b/doc/reference_coverage.xml
index 086d58bff..8da79c8c9 100644
--- a/doc/reference_coverage.xml
+++ b/doc/reference_coverage.xml
@@ -176,16 +176,12 @@ SELECT true = ALL (
       </tgroup>
     </informaltable>
 
-      <programlisting>CREATE TABLE coverage (id integer, geom geometry);
-
-INSERT INTO coverage VALUES
-  (1, '(POLYGON ((160 150, 110 130, 90 100, 90 70, 60 60, 50 10, 30 30, 40 50, 25 40, 10 60, 30 100, 30 120, 20 170, 60 180, 90 190, 130 180, 130 160, 160 150), 
-  (40 160, 50 140, 66 125, 60 100, 80 140, 90 170, 60 160, 40 160))'),
-  (2, 'POLYGON ((40 160, 60 160, 90 170, 80 140, 60 100, 66 125, 50 140, 40 160))'),
-  (3, 'POLYGON ((110 130, 160 50, 140 50, 120 33, 90 30, 50 10, 60 60, 90 70, 90 100, 110 130))' 
-  (4, 'POLYGON ((160 150, 150 120, 160 90, 160 50, 110 130, 160 150))' 
-  );
-
+      <programlisting>WITH coverage(id, geom) AS (VALUES
+  (1, 'POLYGON ((160 150, 110 130, 90 100, 90 70, 60 60, 50 10, 30 30, 40 50, 25 40, 10 60, 30 100, 30 120, 20 170, 60 180, 90 190, 130 180, 130 160, 160 150), (40 160, 50 140, 66 125, 60 100, 80 140, 90 170, 60 160, 40 160))'::geometry),
+  (2, 'POLYGON ((40 160, 60 160, 90 170, 80 140, 60 100, 66 125, 50 140, 40 160))'::geometry),
+  (3, 'POLYGON ((110 130, 160 50, 140 50, 120 33, 90 30, 50 10, 60 60, 90 70, 90 100, 110 130))'::geometry),
+  (4, 'POLYGON ((160 150, 150 120, 160 90, 160 50, 110 130, 160 150))'::geometry)
+)
 SELECT id, ST_AsText(ST_CoverageSimplify(geom, 30) OVER ())
   FROM coverage;
 

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

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


hooks/post-receive
-- 
PostGIS