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

_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to