Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id EFA582E006F for ; Mon, 28 Apr 2008 04:34:53 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 67797-10 for ; Mon, 28 Apr 2008 04:34:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from blu139-omc1-s20.blu139.hotmail.com (blu139-omc1-s20.blu139.hotmail.com [65.55.175.160]) by developer.postgresql.org (Postfix) with ESMTP id 390A02E002D for ; Mon, 28 Apr 2008 04:34:51 -0300 (ADT) Received: from BLU129-W15 ([65.55.162.183]) by blu139-omc1-s20.blu139.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Mon, 28 Apr 2008 00:34:50 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_e2469974-0d4c-40d7-aff7-13db7ae5406d_" X-Originating-IP: [212.15.232.100] From: J Fran To: Lista Correo PostgreSQL Subject: Problem with GeomFromText('POINT(... Date: Mon, 28 Apr 2008 09:34:49 +0200 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 28 Apr 2008 07:34:50.0035 (UTC) FILETIME=[57562030:01C8A902] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.197 tagged_above=0 required=5 tests=FROM_LOCAL_NOVOWEL=3.196, HTML_MESSAGE=0.001 X-Spam-Level: *** X-Archive-Number: 200804/268 X-Sequence-Number: 29032 --_e2469974-0d4c-40d7-aff7-13db7ae5406d_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I'm trying upate a group of records. In the table I have 1 field geometry a= nd 2 fields ineteger with long. and lat. everyone. I try to update the fiel= d geometry with point(long lat). =20 I use this update with numbers and this is ok.UPDATE public."Contenedor" SE= T ubicacion =3D GeomFromText('POINT(1.9845 49.8543)', 4326) but when i chan= ge the number by a field this is not ok. : UPDATE public."Contenedor" SET u= bicacion =3D GeomFromText('POINT(public.Contenedor.long 49.8543)', 4326) I= have this error. ERROR: parse error - invalid geometry Estado SQL:XX000 Contexto:SQL functio= n "geomfromtext" statement 1 Everyone can tell ma some solution please. =20 Thank you. =20 =20 _________________________________________________________________ Discover the new Windows Vista http://search.msn.com/results.aspx?q=3Dwindows+vista&mkt=3Den-US&form=3DQBR= E= --_e2469974-0d4c-40d7-aff7-13db7ae5406d_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 updat= e the field geometry with point(long lat).
 
I use this update with numbers and this is ok.

UPDATE
public."Co= ntenedor"
SET
ubicacion =3D GeomFromText('POINT(1.9845 49.8543)', 4= 326)

but when i change the number by a field this is not ok. :
=
UPDATE
public."Contenedor"
SET
ubicacion =3D 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! = --_e2469974-0d4c-40d7-aff7-13db7ae5406d_--