Re: Math Operators

by Michael Smedberg-2 :: Rate this Message:

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

Could you store the numbers "1" and "-1", and then do

+ (one_or_minus_one * 15000)

That is, subtraction is the same as addition of the negative?

From: postgis-users-bounces@... [mailto:postgis-users-bounces@...] On Behalf Of Bob Pawley
Sent: Wednesday, July 01, 2009 11:35 AM
To: PostGIS Users Discussion
Subject: [postgis-users] Math Operators

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-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

« Return to Thread: Math Operators