[postgis-users] modifying xy coordinates in the geom column

[Aaron Licker]

Hi all,

I am trying to offset some point data that has been snapped to some lines.
Ideally a point that is on a vertical line would get offset in the x direction by 2m and in the y direction by 2m if it has an even address etc.
i am running a query such as:
 update sketch_bars set the_geom = geomfromtext('POINT((x(the_geom)+2) (y(the_geom)+2))',32190) where "id" = 458

but of course i get the 

ERROR:  parse error - invalid geometry

any help would be much appreciated,

Aaron

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060622/81576c07/attachment.html>