[postgis-users] HELP adding spatial field to table

[Michael Smedberg]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users