[postgis-users] Extent on multiple tables

Lars Rößiger lars.roessiger at d33.net
Fri Oct 21 03:43:27 PDT 2005

Thank you! Works like a charm :-)


strk at refractions.net schrieb:
> You might try:
> 	select extent(g) from (
> 		select the_geom from table1
> 		union all
> 		select the_geom from table2
> 	) as foo;
> Consider also using the estimated_extent() function, which should
> give you a much faster result.
> --strk;
> On Fri, Oct 21, 2005 at 12:00:17PM +0200, Lars Rößiger wrote:
>>is there a possibility to use the Extent-function on multiple tables in
>>one query? My map layers (built-up areas, waterlines, etc.) are in
>>separate tables, but to build the map I need to know the cumulative
>>Extent of all layers. I tried INNER JOIN and even subselects within the
>>Extent-function -- without success.
>>Thank you,
>>postgis-users mailing list
>>postgis-users at postgis.refractions.net
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list