From: | Hyung Joo Lee <procarrie(at)imrc(dot)kist(dot)re(dot)kr> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | the problem about the geometry |
Date: | 2010-02-18 00:55:04 |
Message-ID: | 3E94D039A2B82544B3E7D48F924B0B255D0F7EB256@base.imrc.kist.re.kr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Dear all.
I input the command below:
UPDATE iphone_en SET location = GeometryFromText(cast(POINT('||cast(latitude as varchar(10))||', '||cast(longitude as varchar(10))||') as geometry),-1);
ERROR : invalid input syntax for type double precision: "||cast(latitude as varchar(10))||"
DB has some fields(name, id, ----, latitude, longitude, ----, location).
I made the field of location using by addgeometrycolumn.
I want to input the value(latitude, longitude) to location.
How can I input the right command?
Best regards and thanks in advance
Kevin.
From | Date | Subject | |
---|---|---|---|
Next Message | Thorne, Francis | 2010-02-18 08:46:07 | Re: AIX - Out of Memory |
Previous Message | dx k9 | 2010-02-17 14:36:09 | Postgresql & PAM & AD |