[postgis-users] update a geometry field from real fields from postgis datatable

francis francis.milhau at free.fr
Tue Mar 13 13:52:39 PDT 2012


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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120313/38338d81/attachment.html>

More information about the postgis-users mailing list