[postgis-users] Math Operators

[Sean]

It's not clear what you're trying to do but can you simply store the
15000 as positive or negative?  Then you always add.  Adding a
negative is same as subtracting.

  Sean


On Jul 1, 2:35 pm, "Bob Pawley" <rjpaw... at shaw.ca> wrote:
> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-us... at postgis.refractions.nethttp://postgis.refractions.net/mailman/listinfo/postgis-users