Database Reference
In-Depth Information
WITH astext AS (
SELECT ST_AsText(the_geom) AS pstring
FROM (
SELECT (ST_DumpPoints(the_geom)).geom AS
the_geom, gid AS gid FROM
chp04.voronoi_test_points
) AS point_dump
),
astextcomma AS (
SELECT replace(pstring, ' ', ',') AS pstring
FROM astext
)
SELECT * FROM astextcomma
This will result in the following output:
pstring
-------------
POINT(5,7)
POINT(2,8)
POINT(10,4)
POINT(1,15)
POINT(4,9)
POINT(8,3)
POINT(5,3)
POINT(20,0)
(8 rows)
Performasimilarsetofreplacementsforthestartandendbracketsusingthefollow-
ing query:
WITH astext AS (
SELECT ST_AsText(the_geom) AS pstring
FROM (
SELECT (ST_DumpPoints(the_geom)).geom AS
