hello,

I have a table with two columns '*lat*' and '*lon*' : it is real type double and a column '*geom*' type geometry; how to make a request to update my column geom from 'lat' and 'lon' columns ?
somewhat I wrote this :
*update mytable set geom = 'POINT (' | | lat | | '' | | lon | | ')';*
but it does not work!
Do you have an idea?
thank you


my config
Windows XP Pro SP2
PostGIS 1.5.3
--
------------------------------------------------------------------------

        

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to