Thanks for the prompt response. And youre right there are some such values. Is there a work around?
Rich -----Original Message----- From: Michael Smedberg [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 11, 2007 6:55 PM To: [EMAIL PROTECTED]; PostGIS Users Discussion Subject: RE: [postgis-users] HELP adding spatial field to table Are you sure that x and y always have legit values? If one were null or the zero-length string, I think you'd get an error like that. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Heimann [C] Sent: Tuesday, December 11, 2007 3:44 PM To: 'PostGIS Users Discussion' Subject: [postgis-users] HELP adding spatial field to table All, Im getting some strange behavior that I cant explain and sadly know its likely trivial. My pursuit is simple, add a spatial filed to a table containing x,y. First. AddGeometryColumn SELECT AddGeometryColumn( 'crimetest', 'geom', 4326, 'POINT', 2) Next (and where the trouble lies) UPDATE crimetest SET geom = PointFromText('POINT(' || x || ' ' || y || ')', 4326) This is the error I receive. ERROR: Invalid OGC WKT (too short) SQL state: XX000 Context: SQL function "geomfromtext" statement 1 SQL function "pointfromtext" statement 1 Can anyone shed some light on this? Thanks Rich _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
