Just to add to the other good advice you've already received: If the data are in the format with an actual slash, as a single string (not sure from your email), then string functions can help you get to the point where you can divide, or create geometry, if that's where you're at: http://www.postgresql.org/docs/8.4/interactive/functions-string.html
Mark On Tue, Jul 12, 2011 at 8:58 AM, Yamini Singh <yaminijsi...@live.com> wrote: > *Hi All,* > > *I have a column 'geocode' in a table which has attributes like 2329/4727 > now I would like to convert these **attributes **in another column to > 'lat' and 'long'. For example, 'Lat' column will have **attribute '**23.29' > and 'long' column will have **attribute ** '47.27'.* > > *Is there a way through which this can be converted automatically by a > query or so.* > > *Looking fwd..Thanks* > > *YJ* >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
