[postgis-users] constructing new geometry from existing columns

[John Cartwright]

Hello All,

I'm trying to populate a newly-added geometry column in a table using 
two existing columns: LON, LAT.  The only way I see to do it seems a 
little clumsy:

update  grid_points set SHAPE = GeomFromText('POINT(' || lon ||' ' || 
lat || ')',4326);

Is there a better way than constructing a WKT string?

Thanks!

-- john

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