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
