Update all geometry points by adding/subtracting from XY
This makes absolutely no sense, but you would want to do something like this

UPDATE myTable
  SET geoPoint = Point( ST_X(geoPoint)+0.1, ST_Y(geoPoint)-0.1 );


This will move absolutely in the base unit of the SRS.