large polygons of data type geography showing strange behaviour
we have some problems / questions concerning the use of geography data with PostGIS. As far as I understood, it is not possible to use the latitude span from -90 to 90 in polygons / bounding boxes (https://trac.osgeo.org/postgis/ticket/2495),
if you want to construct a polygon. Otherwise you get the follwing message
The result is, that, if you enlarge the polygon, the one point (0,0) goes outside, the other point goes (180,0) inside. The only explanation, I can imagine, is, that PostGIS choose always the polygon, which has
a longitude extension which is smaller/equal 180. If this is true, this is a real problem. If you are using the geography type, it is not possible to use polygons, which has a longitude extension larger than 180. Normally this should be solved with the orientation
of the poylgon, but the orientation has obviously no effect.