[SCM] PostGIS branch master updated. 3.6.0rc2-152-g19e25a659
git at osgeo.org
git at osgeo.org
Mon Oct 20 09:12:55 PDT 2025
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 19e25a659e825484fcd8a013b5364a2621ae46b5 (commit)
from 01c39190148c91ec62889fadbabc25afb7f707fd (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 19e25a659e825484fcd8a013b5364a2621ae46b5
Author: Martin Davis <mtnclimb at gmail.com>
Date: Mon Oct 20 09:12:46 2025 -0700
Improve doc example for ST_DumpRings
diff --git a/doc/reference_accessor.xml b/doc/reference_accessor.xml
index 016122e20..ac5864537 100644
--- a/doc/reference_accessor.xml
+++ b/doc/reference_accessor.xml
@@ -918,28 +918,21 @@ FROM (
<refsection>
<title>Examples</title>
- <para>General form of query.</para>
+ <para>Extracting all rings as polygons.</para>
<programlisting>SELECT polyTable.field1, polyTable.field1,
(ST_DumpRings(polyTable.geom)).geom As geom
FROM polyTable;
</programlisting>
- <para>A polygon with a single hole.</para>
-<programlisting>SELECT path, ST_AsEWKT(geom) As geom
+ <para>Extracting shell and holes from a polygon.</para>
+<programlisting>SELECT path, ST_AsText(geom) As geom
FROM ST_DumpRings(
- ST_GeomFromEWKT('POLYGON((-8149064 5133092 1,-8149064 5132986 1,-8148996 5132839 1,-8148972 5132767 1,-8148958 5132508 1,-8148941 5132466 1,-8148924 5132394 1,
- -8148903 5132210 1,-8148930 5131967 1,-8148992 5131978 1,-8149237 5132093 1,-8149404 5132211 1,-8149647 5132310 1,-8149757 5132394 1,
- -8150305 5132788 1,-8149064 5133092 1),
- (-8149362 5132394 1,-8149446 5132501 1,-8149548 5132597 1,-8149695 5132675 1,-8149362 5132394 1))')
- ) as foo;
- path | geom
-----------------------------------------------------------------------------------------------------------------
- {0} | POLYGON((-8149064 5133092 1,-8149064 5132986 1,-8148996 5132839 1,-8148972 5132767 1,-8148958 5132508 1,
- | -8148941 5132466 1,-8148924 5132394 1,
- | -8148903 5132210 1,-8148930 5131967 1,
- | -8148992 5131978 1,-8149237 5132093 1,
- | -8149404 5132211 1,-8149647 5132310 1,-8149757 5132394 1,-8150305 5132788 1,-8149064 5133092 1))
- {1} | POLYGON((-8149362 5132394 1,-8149446 5132501 1,
- | -8149548 5132597 1,-8149695 5132675 1,-8149362 5132394 1))</programlisting>
+ 'POLYGON ((1 9, 9 9, 9 1, 1 1, 1 9), (2 2, 2 3, 3 3, 3 2, 2 2), (4 2, 4 4, 6 4, 6 2, 4 2))');
+
+ path | geom
+------+--------------------------------
+ {0} | POLYGON((1 9,9 9,9 1,1 1,1 9))
+ {1} | POLYGON((2 2,2 3,3 3,3 2,2 2))
+ {2} | POLYGON((4 2,4 4,6 4,6 2,4 2))</programlisting>
</refsection>
<!-- Optionally add a "See Also" section -->
-----------------------------------------------------------------------
Summary of changes:
doc/reference_accessor.xml | 27 ++++++++++-----------------
1 file changed, 10 insertions(+), 17 deletions(-)
hooks/post-receive
--
PostGIS
More information about the postgis-tickets
mailing list