[postgis-users] Re: [Mapserver-users] Finding Extent

David Blasby dblasby at refractions.net
Mon May 10 09:33:10 PDT 2004


Tyler Mitchell wrote:
> Two ideas,
> 1) Won't "select extent(the_geom)..." give you something you can use, 
> without the need to repeat that step four times?


SELECT xmin(extent), ymin(extent), xmax(extent), ymax(extent) FROM
   (SELECT extent(the_geom) as extent FROM <table> WHERE <where clause>) 
as foo;

dave



More information about the postgis-users mailing list