[postgis-users] Empty Geometry

Bob Pawley rjpawley at shaw.ca
Tue Jun 9 13:27:18 PDT 2009

In the past, when the update conditions are not met, the update transaction doesn.t finalize.

However when I run the following update function where ST_GeometryType(temp_arrow.ithe_geom) = 'ST_MultiLineString'  is not true, then the return is a null value.

Is there a workaround to this problem??

 update temp_arrow
 set ip_target  = 
 (  select (st_translate(graphics.utilities_dgm.the_geom, 
 st_x (st_startpoint(temp_arrow.ithe_geom))-
 st_x (st_startpoint(graphics.utilities_dgm.the_geom)) ,
 st_y (st_centroid(temp_arrow.ithe_geom))-
 st_y (st_startpoint(graphics.utilities_dgm.the_geom)))) 
  from graphics.utilities_dgm, temp_arrow, p_id.p_id, p_id.processes
  where temp_arrow.graphic_id = p_id.p_id.process_graphic_id
  and p_id.p_id.process_id = p_id.processes.process_id
  and p_id.processes.fluid_id = temp_arrow.fluid_id
  and ST_GeometryType(temp_arrow.ithe_geom) = 'ST_MultiLineString'  
  and graphics.utilities_dgm.utilities_description = 'Arrow_Flow_Direction' 
  and graphics.utilities_dgm.orientation = p_id.p_id.ip_orient );

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090609/06dfd97c/attachment.html>

More information about the postgis-users mailing list