I have a setset of geometrygeometry in my postgresPostgreSQL table that consists of Points,Linestrings & PolygonsPoints, Linestrings & Polygons. From this set I need to create a subsetsubset of geometries which intersectsintersects with each other. I need a method without loopingwithout looping through each one of them as there can be more than 1000 geometries at once.
I need to fetch the geometries that are marked in red in this image