[postgis-users] How remove a single part from a multipart geometry

[Mike Toews]

There aren't any delete/remove/drop geometry functions, so you would
need dissect and re-create the geometry.

But, if you want to do this visually, this is easy. If you have a
recent version of QGIS, just start editing and use the "Delete part"
edit tool.

-Mike

On 23 September 2010 10:28, Andrea Peri 2007 <aperi2007 at gmail.com> wrote:
>  Hi,
>
> I need to remove a single part from a multipart geometry.
>
> For example having a multipolygon with three part I need to remove one of
> these parts so the result is a multipolygon with two parts.
>
> In postgis I find a function to extract a single part from a multipart (
> ST_GeometryN ) but don't find nothing to remove one.
>
> So the only method I know is re-create the geometry skipping the part
> unwanted, but I hope to find somethink more simple.
>
> Thx,
>
> Andrea.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>