[postgis-users] HELP adding spatial field to table

[Richard Heimann [C]]

 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