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

David Blasby dblasby at refractions.net
Mon May 10 12:33:10 EDT 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;


More information about the mapserver-users mailing list