[postgis-users] Math Operators

Bob Pawley rjpawley at shaw.ca
Wed Jul 1 11:35:00 PDT 2009


Hi

I have an expression such as -

select ST_distance(st_centroid(p_id.p_id.the_geom), st_boundary(p_id.p_id.the_geom))/2 + 15000
   from p_id.p_id
   where p_id.p_id.process_id = '1012' ;

This works

I can access the number 15000 from a table as a variable. 

I want to be able to also access the + (or -) from a table as a variable but can't figure out how to do this.

Is it possible to store math operators and access them from a table??

Bob
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090701/97707e32/attachment.html>


More information about the postgis-users mailing list