[postgis-users] Calculate Bounding Box of a point type table

[Daryl Herzmann]

On Wed, Aug 18, 2010 at 10:24 AM, Appel, Tony <tony.appel at navteq.com> wrote:
> I find out what the bounding box is for a table that contains point geometry.
>
> Newb alert: I have read about box2b, st_extent, st_envelope but none of those seem to be exactly what I need.
>
> Thanks in advance.

Hello,

Could you elaborate on why ST_Extent is not providing what you need?
For me, it works how I want :)

 select ST_Extent(geom) from lsrs_2010;
          st_extent
------------------------------
 BOX(-168.08 1.32,-64.7 70.6)
(1 row)

daryl