<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18828">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>Hi</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I have a table holding a number of rows of points
which I want to translate from covering Box 1 to covering Box 2.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>When I use the following all of the points are
translated to the same central position (200 points stacked upon each
other)</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial> insert into fluids (one)<BR> select
st_translate(graphics.point_grid.the_geom,<BR> st_x(st_centroid(library.dgm_process.the_geom))
-<BR> st_x(st_centroid(graphics.point_grid.the_geom)),<BR> st_y(st_centroid(library.dgm_process.the_geom))
-<BR> st_y(st_centroid(graphics.point_grid.the_geom)))<BR> from
library.dgm_process, graphics.point_grid<BR> where
library.dgm_process.process_number = '1'<BR> and graphics.point_grid.number
= '1' ;</FONT></DIV>
<DIV><FONT size=2 face=Arial>I've tried variations of the above without
success.</FONT></DIV><FONT size=2 face=Arial>
<DIV><BR>When the same points are collected in a st_union operation occupying a
single row the preceding works well.</DIV>
<DIV> </DIV>
<DIV>I need these points in separate entities in order to select particular
points, using the following -</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>insert into fluids (one)<BR> select
st_translate(graphics.point_grid.the_geom,<BR> st_x(st_centroid(library.dgm_process.the_geom))
-<BR> st_x(st_centroid(graphics.point_grid.the_geom)),<BR> st_y(st_centroid(library.dgm_process.the_geom))
-<BR> st_y(st_centroid(graphics.point_grid.the_geom)))<BR> from
library.dgm_process, graphics.point_grid<BR> where
library.dgm_process.process_number = '1'<BR> and graphics.point_grid.number
= '1' </FONT></DIV>
<DIV><FONT size=2 face=Arial> and st_within( graphics.point_grid.the_geom,
st_box2d(library.dgm_process.the_geom)) = 't'<BR> and
graphics.point_grid.the_geom <<| st_centroid(library.dgm_process.the_geom)
;</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Is there some method of which I am
unaware, for translating single points to a new location with the same
relationship one to another??</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Bob</FONT></DIV>
<DIV> </DIV></BODY></HTML>