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

[Paul Ramsey]

you need a space between the ordinates and you need to put the longitude
first.
P.

On Tue, Mar 13, 2012 at 1:52 PM, francis <francis.milhau at free.fr> wrote:

>   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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120313/e71d2a83/attachment.html>