I tried
select st_astext(geom) from table where st_pointn(geom, 1) = st_pointn(geom, 2)But I get some results which don't match the criteria. For example: LINESTRING(-117.1642086 34.2779308,-117.1642145 34.2779305)
Why do I get the wrong answer for that query?
(I have since changed my query to use st_length).
أكثر...
select st_astext(geom) from table where st_pointn(geom, 1) = st_pointn(geom, 2)But I get some results which don't match the criteria. For example: LINESTRING(-117.1642086 34.2779308,-117.1642145 34.2779305)
Why do I get the wrong answer for that query?
(I have since changed my query to use st_length).
أكثر...