<!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.18876">
<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've been attempting to use CASE to establish the
spatial point in the following expression.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Update p_id.image<BR> set the_geom =
<BR> (select
st_translate(library.dgm_device.the_geom, <BR> st_x
(st_centroid(p_id.p_id.othe_geom)) - <BR> st_x
(st_centroid(library.dgm_device.ithe_geom)) , <BR> st_y
(st_centroid(p_id.p_id.othe_geom)) - Select Case when p_id.devices.status =
'Pump #1'<BR> and p_id.devices.devices_id = '3614'<BR> then - 10000 -
<BR> st_y (st_centroid(library.dgm_device.the_geom)))<BR> from
p_id.p_id, library.dgm_device, p_id.processes, processes_count,
p_id.devices <BR> where library.dgm_device.description = 'In Line
Pump'<BR> and library.dgm_device.orientation = ta_orientation<BR> and
p_id.p_id.p_id_id = processes_count.p_id_id<BR> and p_id.p_id.process_id =
p_id.processes.process_id<BR> and p_id.devices.devices_id =
'3614'<BR> and p_id.processes.fluid_id =
p_id.devices.fluid_id) <BR> from p_id.devices<BR> where
p_id.image.fluid_id = p_id.devices.fluid_id<BR> and p_id.devices.devices_id
= '3614'<BR> and p_id.image.text_ = 'Pump #1'<BR> and
p_id.image.device_id = '3614';</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I get - "ERROR: syntax error at or near
"Select"<BR>LINE 14: st_y (st_centroid(p_id.p_id.othe_geom)"</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Any help would be appreciated.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Bob</FONT></DIV></BODY></HTML>