[postgis-users] Update Error

Donald Ijams dsijams at gmail.com
Tue Aug 5 15:00:35 PDT 2008

When I attempt to update a geometry column from a field in another table 

UPDATE recent
SET xypoint = ST_GeomFromText((raw.x, raw.y),102249)        
from raw
where recent.casenum=raw.casenum;

I get:

*SQL error:*

ERROR:  function st_geomfromtext(record, integer) does not exist
LINE 3: xypoint = ST_GeomFromText((raw.x, raw.y),102249)  
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Probably something simple, but I'm not seeing it.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080805/7f4711de/attachment.html>

More information about the postgis-users mailing list