Hot answers tagged routing
You can use the pgRouting function pgr_nodeNetwork, which will create nodes at intersections of linestrings. So in your case it will split the linestring into two geometries. But there is a danger that intersections, that should not be connected (ie. over- or under-passes), will also get broken into two segments.
Only top voted, non community-wiki answers of a minimum length are eligible