Hello,

I'm trying to split up a line using points into several smaller lines. I'm
using ST_Split but I don't understand how to combine the returned values
into a line. My code is as follows:

SELECT
   ST_Dump(ST_Split(g.geom, blade.geom)) AS geom
FROM
    points as blade,
    lines as g
WHERE
    ST_Intersects(g.geom, blade.geom)

I've tried using a few different geometry constructors such as
ST_LineFromMultiPoint() and ST_GeomFromEWKB() to convert what ST_Dump()
returns to create lines but my syntax/approach is not correct. What is the
correct approach?

Thanks,
David
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to