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

[francis]

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
-- 
------------------------------------------------------------------------

	

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