title: Find intersecting coordinates from the same table postgis
body: <p>I currently have two tables one which is for states and holds a unique ID, the state name, and the coordinates of the state.  The second one is for urban areas which holds a unique ID, the urban area name, and the coordinates of that area.  I am trying to find which urban areas intersect each other while excluding self-intersections (meaning if area A intersects area B and area B intersects area A, only return one result, not both)</p>
  
  <p>I currently have the code:</p>
  
  <pre><code>SELECT s.name 
  FROM urbanTable AS s, stateTable as a 
  WHERE ST_Intersects(s.coords, s.coords) 
  AND (a.gid != s.gid) 
  GROUP BY s.name;
  </code></pre>
  
  <p>However this is not returning the correct amount of results.  Any and all help is greatly appreciated! Thank you!</p>