[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

Sorry:

Hi,

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