[postgis-users] Update Error

[Donald Ijams]

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

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.

Don

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