<div dir="ltr">SELECT ASTEXT(thegeom);<br><br>That should do what you are looking for.<br clear="all">--<br>Nathan Gerber<br>
<br><br><div class="gmail_quote">On Mon, Aug 11, 2008 at 5:05 PM, David Calle <span dir="ltr"><<a href="mailto:davydky@gmail.com">davydky@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir="ltr">Hi List, <br><br>I need to convert geometry information to the GPS format:<br><br>01010000202D610000E81559FA0BD62541DA82728C04776241<br>to <br>lat: -2.9033 long: -79.138<br><br>Using PostGis functions like GeometryfromText.... thanks<br>
</div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@openlayers.org">Users@openlayers.org</a><br>
<a href="http://openlayers.org/mailman/listinfo/users" target="_blank">http://openlayers.org/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>