[postgis-users] Clip and select outside an polygon

[Júlio Almeida]

Hello,


I need to clip/trim from a geometry the geometries that
ST_Intersection(r.the_geom, m.the_geom) and select the geometries that area
outside of an ST_Intersection(r.the_geom, m.the_geom).
I have attached an image to illustrate.

How can it be done?
Thanks,

julio
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110419/4db0a5bd/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: imagel.jpg
Type: image/jpeg
Size: 34598 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110419/4db0a5bd/attachment.jpg>