I haven't tried them specifically with the geography type, but I would assume that ST_AsText(), ST_X(), and ST_Y() should work.
Something like: SELECT ST_X(myGeogColName), ST_Y(myGeogColName) FROM myTable; Take a look at the docs here: http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2575402 David. On Wed, Jan 5, 2011 at 8:46 AM, W. Matthew Wilson <m...@tplus1.com> wrote: > I'm storing destinations as geography POINT columns. Is there some > function that converts a geography(POINT) column's latitude and > longitude into plain numbers? > > I'm using google maps to draw markers on a map for these destinations > and I need to pass in the latitude and longitude as a pair of numbers. > > Thanks in advance! > > Matt > -- > W. Matthew Wilson > m...@tplus1.com > http://tplus1.com > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
