Re: [SQL] a spatial table's bounding box

2011-10-05 Thread Asli Akarsakarya
Thank you very much. >I would try >SELECT st_envelope( st_collect(geom) ) FROM roads; >HTH, Filip>> >I want to get the extensions of spatial table. Say that there is a spatial >table named 'roads', and a some road geometry inside. I want to fetch the >bounding box (envelope or extension) for t

Re: [SQL] a spatial table's bounding box

2011-09-23 Thread Filip RembiaƂkowski
2011/9/22 Asli Akarsakarya > > I want to get the extensions of spatial table. Say that there is a spatial > table named 'roads', and a some road geometry inside. I want to fetch the > bounding box (envelope or extension) for that table, that means for all the > roads that it has. > > Accordin