[postgis-users] Trimming Polygons that exceed bounding box boundary

[Stephen Woodbridge]

On 2/23/2012 10:28 AM, Rebecca Clarke wrote:
> Hi
> Newbie here!
> I have a bounding box and I'm retrieving all polygons that intersect
> with it using st_intersect. Some of the polygons are large and exceed
> the boxes boundary. What function would I use to trim these large
> polygons so I still have them but only see the part of them that
> intersect with the box.

st_intersection(bbox, the_geom)