[postgis-users] Multilinestring "complex" geometry.

[Stephen Woodbridge]

On 11/28/2012 2:28 AM, Raffaello Bertini wrote:
> how can i make a multilinestring value of a complex geometry (ex: with
> line intersection )
> I need for routes.
> I like to have the route in one value.
> I thought that multilinestring was perfect, but not support complex
> geometry.
> Else
> I have one route splitted into some linestring value... not the best if
> i store multiple route.
>
> is there the possibility to make a multilinestring value that support
> intersection?
> thx in advice.

Write a plpgsql stored procedure, that iterates over the geometryn() of 
the multilinestring and intersects each one and returns the result you want.

-Steve W