I've used ST_Intersects and ST_Crosses but between two different tables. I have a table of streets and intersections want to know them. For example select all streets that cross the Street A. Can anyone give me an example?
Edited for karpfen**
This is my table of streets, each street segment is a geometry table. The image of the QGIS layer can better understand, analyze and think it would be appropriate to use ST_Touches and select geometry that touches the other at its end. But how do it in the same table?? I can not do a join.