Обсуждение: Problem with GeomFromText('POINT(...
I'm trying upate a group of records. In the table I have 1 field geometry and 2 fields ineteger with long. and lat. everyone. I try to update the field geometry with point(long lat).
I use this update with numbers and this is ok.
UPDATE
public."Contenedor"
SET
ubicacion = GeomFromText('POINT(1.9845 49.8543)', 4326)
but when i change the number by a field this is not ok. :
UPDATE
public."Contenedor"
SET
ubicacion = GeomFromText('POINT(public.Contenedor.long 49.8543)', 4326)
I have this error.
ERROR: parse error - invalid geometry
Estado SQL:XX000
Contexto:SQL function "geomfromtext" statement 1
Everyone can tell ma some solution please.
Thank you.
Discover the new Windows Vista Learn more!
I use this update with numbers and this is ok.
UPDATE
public."Contenedor"
SET
ubicacion = GeomFromText('POINT(1.9845 49.8543)', 4326)
but when i change the number by a field this is not ok. :
UPDATE
public."Contenedor"
SET
ubicacion = GeomFromText('POINT(public.Contenedor.long 49.8543)', 4326)
I have this error.
ERROR: parse error - invalid geometry
Estado SQL:XX000
Contexto:SQL function "geomfromtext" statement 1
Everyone can tell ma some solution please.
Thank you.
Discover the new Windows Vista Learn more!
The "long" column isn't being referenced the way you've written this, because its inside of a quoted string. You need to construct the string GeomFromText('POINT(' || public.Contenedor.long || ' 49.8543)', 4326) 2008/4/28 J Fran <jllfnpg@hotmail.com>: > > I'm trying upate a group of records. In the table I have 1 field geometry > and 2 fields ineteger with long. and lat. everyone. I try to update the > field geometry with point(long lat). > > I use this update with numbers and this is ok. > > UPDATE > public."Contenedor" > SET > ubicacion = GeomFromText('POINT(1.9845 49.8543)', 4326) > > but when i change the number by a field this is not ok. : > > UPDATE > public."Contenedor" > SET > ubicacion = GeomFromText('POINT(public.Contenedor.long 49.8543)', 4326) > > > I have this error. > > ERROR: parse error - invalid geometry > Estado SQL:XX000 > Contexto:SQL function "geomfromtext" statement 1 > > Everyone can tell ma some solution please. > > Thank you. > > > > > ________________________________ > Discover the new Windows Vista Learn more! -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 183 8059 5 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South Africa