<!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.18783">
<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 would like to have mathematical operators
accessed from a table ie. the minus in the red expression - in
the following function to +.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><BR><FONT size=2 face=Arial> update fluids<BR> set
flow_arrow_ithe_geom = <BR> ( select
(st_translate(graphics.utilities_dgm.the_geom, <BR>
st_x(p_id.p_id.ithe_geom) -<BR> <FONT color=#ff0000>
(ST_distance(p_id.p_id.the_geom, p_id.p_id.ithe_geom)/
(graphics.ip_matrix.flow_arrow_divider))</FONT></FONT><FONT size=2><FONT
face=Arial><FONT color=#ff0000> -<BR> st_x
(st_startpoint(graphics.utilities_dgm.the_geom))</FONT> ,<BR> st_y
(p_id.p_id.ithe_geom) - <BR> st_y
(st_startpoint(graphics.utilities_dgm.the_geom)))) <BR> from
graphics.utilities_dgm, p_id.p_id, p_id.processes <BR> where
p_id.p_id.process_id = p_id.processes.process_id <BR> and
p_id.processes.fluid_id = fluids.fluid_id<BR> and
graphics.utilities_dgm.utilities_description = 'Arrow_Flow_Direction' <BR>
and graphics.utilities_dgm.orientation = p_id.p_id.ip_orient )<BR> from
p_id.p_id, graphics.ip_matrix, p_id.processes<BR> where
ST_GeometryType(p_id.p_id.ithe_geom) = 'ST_Point'<BR> and
graphics.ip_matrix.ip_number = p_id.processes.ip_number<BR> and
p_id.processes.fluid_id = fluidid<BR> and graphics.ip_matrix.spatial_ref =
p_id.p_id.proc_graphic_position <BR> and (p_id.p_id.number_of_ips
> graphics.ip_matrix.ip_total<BR> or p_id.p_id.number_of_ips
= graphics.ip_matrix.ip_total)<BR> and p_id.p_id.process_id =
p_id.processes.process_id<BR> and p_id.processes.fluid_id =
fluidid;<BR></FONT></FONT></DIV>
<DIV><FONT size=2><FONT face=Arial>I've attempted to replace the minus with the
expression (graphics.ip_matrix.factor) which leads to the math operators
column.</FONT></FONT></DIV>
<DIV><FONT size=2><FONT face=Arial></FONT></FONT> </DIV>
<DIV><FONT size=2><FONT face=Arial>I get an error at the first
bracket.</FONT></FONT></DIV>
<DIV><FONT size=2><FONT face=Arial></FONT></FONT> </DIV>
<DIV><FONT size=2><FONT face=Arial>Is there a way around this other than a
second function containing the + operator??</FONT></FONT></DIV>
<DIV><FONT size=2><FONT face=Arial></FONT></FONT> </DIV>
<DIV><FONT size=2><FONT face=Arial>Bob</DIV></FONT></FONT></BODY></HTML>