Mathematical Operators

[Bob Pawley]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi

 

I would like to have mathematical operators accessed from a table ie. the minus in the red expression - in the following function to +.

 

 update fluids
 set flow_arrow_ithe_geom  =
 ( select (st_translate(graphics.utilities_dgm.the_geom,
  st_x(p_id.p_id.ithe_geom) -
  (ST_distance(p_id.p_id.the_geom, p_id.p_id.ithe_geom)/ (graphics.ip_matrix.flow_arrow_divider)) -
 st_x (st_startpoint(graphics.utilities_dgm.the_geom)) ,
 st_y (p_id.p_id.ithe_geom) -
 st_y (st_startpoint(graphics.utilities_dgm.the_geom))))
  from graphics.utilities_dgm, p_id.p_id, p_id.processes  
  where p_id.p_id.process_id = p_id.processes.process_id
  and p_id.processes.fluid_id =  fluids.fluid_id
  and graphics.utilities_dgm.utilities_description = 'Arrow_Flow_Direction'
  and graphics.utilities_dgm.orientation = p_id.p_id.ip_orient )
  from p_id.p_id, graphics.ip_matrix, p_id.processes
  where ST_GeometryType(p_id.p_id.ithe_geom) = 'ST_Point'
  and graphics.ip_matrix.ip_number =  p_id.processes.ip_number
  and p_id.processes.fluid_id = fluidid
  and graphics.ip_matrix.spatial_ref = p_id.p_id.proc_graphic_position
  and (p_id.p_id.number_of_ips >  graphics.ip_matrix.ip_total
  or p_id.p_id.number_of_ips =  graphics.ip_matrix.ip_total)
  and p_id.p_id.process_id = p_id.processes.process_id
  and p_id.processes.fluid_id = fluidid;

I've attempted to replace the minus with the expression (graphics.ip_matrix.factor) which leads to the math operators column.

 

I get an error at the first bracket.

 

Is there a way around this other than a second function containing the + operator??

 

Bob

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users