Read up on CASE http://www.postgresql.org/docs/8.2/static/functions-conditional.html
On Fri, Jul 24, 2009 at 11:43 AM, Bob Pawley<[email protected]> wrote: > I have an expression such as :- > > 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) > > I need the option of either (+) or (-) after st_x(p_id.p_id.ithe_geom), > depending on circumstance. > > At the moment I am writting two expressions. Is there a way of creating one > expression that covers both circumstances? > > Bob > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
