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

[David Blasby]

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