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

[Pedro Doria Meunier]

On 04/02/2012 01:55 PM, Nicolas Ribot wrote:
>>> 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;
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
Thank you very much Nicolas!

-- 
Pedro Doria Meunier
Telf. +351 291 933 006
GSM  +351 915 818 823
Skype: pdoriam

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120404/ed82cd6a/attachment.html>