Database Reference
In-Depth Information
unique id
and
gid
valuesforthispurposeandcarry
STRING_AGG
throughasan
extra column:
WITH astext AS (
SELECT ST_AsText(the_geom) AS pstring, gid
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,
gid
FROM astext
),
startingbracket AS (
SELECT replace(pstring, 'POINT(', '[') AS
pstring, gid
FROM astextcomma
),
endingbracket AS (
SELECT replace(pstring, ')', ']') AS pstring,
gid
FROM startingbracket
),
aggstring AS (
SELECT STRING_AGG(pstring, ',' ORDER BY gid)
FROM endingbracket
)
SELECT * FROM aggstring;
You will get the following result:
string_agg
----------------------------------------------------
