[postgis-users] ST_AsText() from an array of geoms

[Nicolas Ribot]

> Hi,
>
> I'm trying to select ST_AsText from an array of geometries.
> This function doesn't support arrays.
>
> How should I proceed to get the array's geoms as text?
>
> Any help appreciated ;)
>

select st_astext(generate_subscripts(myarray, 1) from mytable;

Nicolas