<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
<font size="+1"><font face="Helvetica, Arial, sans-serif">When I
attempt to update a geometry column from a field in another table with:<br>
<br>
UPDATE recent<br>
SET xypoint = ST_GeomFromText((raw.x, raw.y),102249) <br>
from raw<br>
where recent.casenum=raw.casenum;<br>
<br>
I get:<br>
</font></font>
<p><b>SQL error:</b><br>
</p>
<pre class="data">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.</pre>
<br>
Probably something simple, but I'm not seeing it.<br>
<br>
Don<br>
<br>
</body>
</html>