<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#666666">
On 04/02/2012 01:55 PM, Nicolas Ribot wrote:
<blockquote
cite="mid:CAGAwT=1xP5t8WZe2jK6=nPGcDVGZ-Z80TP3HnfN4ESN84fdAVQ@mail.gmail.com"
type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">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 ;)
</pre>
</blockquote>
<pre wrap="">
select st_astext(generate_subscripts(myarray, 1) from mytable;
Nicolas
</pre>
</blockquote>
<pre wrap="">
Sorry:
Hi,
select st_astext(generate_subscripts(myarray, 1)) from mytable;
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<font size="-1"><font face="Helvetica, Arial, sans-serif">Thank you
very much Nicolas!</font></font><br>
<br>
<pre class="moz-signature" cols="72">--
Pedro Doria Meunier
Telf. +351 291 933 006
GSM +351 915 818 823
Skype: pdoriam</pre>
</body>
</html>