[postgis-users] minimum value of the query result

[Brian Sanjeewa Rupasinghe]

Hi,

I retreive minimum x of each bounding box of some polygons using following
query:

SELECT (min(ST_XMin(BOX2D((ST_Dump(the_geom)).geom)))) as XMin
from building_poly;

How can i find the minimum X of all Xmin coordinatges? Can i use min()?


Cheers, Sanjeewa.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110703/cb9b4ed1/attachment.html>