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

[David William Bitner]

You are calling the functions x() and y() as well as using a column
"the_geom" within single quotes so it is treating it as part of the string
and not as functions/columns.


On 6/22/06, Aaron Licker <aaronlicker at shaw.ca> wrote:
>
>  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
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>


-- 
************************************
David William Bitner
bitner at gyttja.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060622/cddba2b2/attachment.html>