Dear all, I have the table "contours" which stores geography column "coordinates" - these are closed polylines, many of them span a half of a globe.
When I perform select a.id, b.id, ST_Contains(a.coordinates::::geometry, b.coordinates::::geometry) AS result from contours a CROSS JOIN contours b where a.time = '2002-12-31 16:00:00' and b.time = '2002-12-31 16:00:00' then ST_Contains is "true" only on rows with a.id=b.id Maybe I converted geography to geometry incorrectly or I am misusing ST_Contains or my data (note again, some of contours span a half of a globe) is inappropriate for geom functions or smth else? Thank you _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
