[postgis-users] Get Extention

[Pradeep B V]

On Thu, May 15, 2008 at 1:04 PM, Bui Anh Tin <anhtin at gmail.com> wrote:

> Hi all
> I have layer Street in database postgres
> How can i get box(minx, miny, maxx, maxy) contain 3 line  with id (3,5,7)


Did you try

select extent(geometry_column) from Street_layer_table where id in (3,5,7)


Pradeep B V
Mapunity: Geography for development
www.mapunity.in
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080515/28d646bd/attachment.html>