[postgis-users] Splitting multistrings

[Steffen Macke]

Hi Nick,

> I'm trying to split multistrings into individual linestrings using SQL
> within PostGIS, but I cant find an appropriate function.  Is it
> possible to do this using SQL?  If not, does anyone know a way this
> can be done?

Did you have a look at the GeometryN() function?
Together with the PostgreSQL generate_series() and NumGeometries() you
should be able to split your lines accordingly.

Or do you have to insert new vertices at the split points? In this
case, a little bit
of additional information would help.

Regards,

Steffen