[postgis-users]

[Chris Faulkner]

Hello

I am selecting a large polygon (coastline of Great Britain) from my
geometry_field, using a clause like this

geometry_field &&GeometryFromText('BOX3D(189858.0 746543.0,195858.0
750543.0)'::box3d,-1)

This obviously retrieves the whole geometry where it overlaps with the
coastline - a lot of coordinates ! Are there any functions or operators I
can retrieve so that this polygon is clipped to my box and yet retain the
polygon ?

Thanks

Chris