I have a query in my lines and points table.
My lines table includes MULTILINESTRING, MULTILINESTRING Z, LINESTRING geometry type data.
select * from sde.line h2 left join sde.points b on st_intersects(st_startpoint(ST_LineMerge((ST_Dump(h2.shape)).geom)), b.shape);
I am using
st_startpoint(line2.geometry) is coming null. So, I am converting to linestring.
But this throws exception
" ERROR: argument of JOIN/ON must not return a set"
How can I solve this issue?