[postgis-users] dump geometry question

[Nicolas Ribot]

hello all,
> how does one extract the geometry out of a geometry_dump?
>

The dump() function returns a composite type which must be accessed
with parenthesis:

(dump).geom
(dump).path

(or (table.dump).geom, (table.dump).path

 something like:

select astext( (dump).geom) from (select dump(geometryFromText('POINT
(1 1)', -1))  from regionmp) as foo limit 1;
   astext
------------
 POINT(1 1)

Nicolas