[postgis-users] How to Get a coordinates from a Geometry field?

[Ivan Caballero Cano]

Good Day! 

  Excuseme by my wrong English.

   I want to know how to get a coordinates of a spatial field postgis in a PostGreSQL table, in other words I have a table with a geometry field named "the_geom"
and I want to get the coordinates by a SQL consult.

 Select *, coordinateY, CoordinateX from table where "somethin"

Can you get some orientation about this??

Thanks
 		 	   		  
_________________________________________________________________
Comparte tu vida en Perfil de Windows Live. Actualízalo ya!
http://www.actualizatuperfil.com.mx/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091112/003edf66/attachment.html>