[postgis-users] ST_Contains(a.coordinates::::geometry, b.coordinates::::geometry)

Antonio Rodriges antonio.rrz at gmail.com
Tue Aug 9 06:44:48 PDT 2011


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



More information about the postgis-users mailing list