id summary reporter owner description type status priority milestone component version resolution keywords cc 2639 geography ST_Intersection regress difference 2.0.4 and 2.1/2.2.0 robe pramsey "This is another one of those I'm not sure is just a change in algorithm or something wrong: {{{ SELECT ST_AsText(ST_Intersection('POLYGON((-8.1111111 60,-8.16875525879031 59.4147290339516,-8.33947250246614 58.8519497029047,-8.61670226309236 58.3332893009412,-8.98979075644036 57.8786796564404,-9.44440040094119 57.5055911630924,-9.96306080290473 57.2283614024661,-10.5258401339516 57.0576441587903,-11.1111111 57,-11.6963820660484 57.0576441587903,-12.2591613970953 57.2283614024661,-12.7778217990588 57.5055911630924,-13.2324314435596 57.8786796564404,-13.6055199369076 58.3332893009412,-13.8827496975339 58.8519497029047,-14.0534669412097 59.4147290339516,-14.1111111 60,-14.0534669412097 60.5852709660484,-13.8827496975339 61.1480502970953,-13.6055199369076 61.6667106990588,-13.2324314435597 62.1213203435596,-12.7778217990588 62.4944088369076,-12.2591613970953 62.7716385975339,-11.6963820660484 62.9423558412097,-11.1111111 63,-10.5258401339516 62.9423558412097,-9.96306080290474 62.7716385975339,-9.4444004009412 62.4944088369076,-8.98979075644036 62.1213203435596,-8.61670226309237 61.6667106990588,-8.33947250246614 61.1480502970953,-8.16875525879031 60.5852709660484,-8.1111111 60))'::geography, 'POLYGON((-8.1111111 60,-8.16875525879031 59.4147290339516,-8.33947250246614 58.8519497029047,-8.61670226309236 58.3332893009412,-8.98979075644036 57.8786796564404,-9.44440040094119 57.5055911630924,-9.96306080290473 57.2283614024661,-10.5258401339516 57.0576441587903,-11.1111111 57,-11.6963820660484 57.0576441587903,-12.2591613970953 57.2283614024661,-12.7778217990588 57.5055911630924,-13.2324314435596 57.8786796564404,-13.6055199369076 58.3332893009412,-13.8827496975339 58.8519497029047,-14.0534669412097 59.4147290339516,-14.1111111 60,-14.0534669412097 60.5852709660484,-13.8827496975339 61.1480502970953,-13.6055199369076 61.6667106990588,-13.2324314435597 62.1213203435596,-12.7778217990588 62.4944088369076,-12.2591613970953 62.7716385975339,-11.6963820660484 62.9423558412097,-11.1111111 63,-10.5258401339516 62.9423558412097,-9.96306080290474 62.7716385975339,-9.4444004009412 62.4944088369076,-8.98979075644036 62.1213203435596,-8.61670226309237 61.6667106990588,-8.33947250246614 61.1480502970953,-8.16875525879031 60.5852709660484,-8.1111111 60))'::geography)); }}} In PostgreSQL 9.2.4, compiled by Visual C++ build 1600, 32-bit POSTGIS=""2.0.4"" GEOS=""3.4.2-CAPI-1.8.2 r0"" PROJ=""Rel. 4.8.0, 6 March 2012"" GDAL=""GDAL 1.10.0, released 2013/04/24"" LIBXML=""2.7.8"" LIBJSON=""UNKNOWN"" (core procs from ""2.0.4"" need upgrade) RASTER (raster procs from ""2.0.4"" need upgrade) {{{ POLYGON((-8.1111111 59.9999999999987,-8.16875525879031 59.41472903395,-8.33947250246614 58.8519497029029,-8.61670226309236 58.3332893009392,-8.98979075644036 57.8786796564381,-9.44440040094119 57.5055911630899,-9.96306080290473 57.2283614024634,-10.5258401339516 57.0576441587875,-11.1111111 56.9999999999972,-11.6963820660484 57.0576441587875,-12.2591613970953 57.2283614024634,-12.7778217990588 57.5055911630899,-13.2324314435596 57.8786796564381,-13.6055199369076 58.3332893009392,-13.8827496975339 58.8519497029029,-14.0534669412097 59.41472903395,-14.1111111 59.9999999999987,-14.0534669412097 60.5852709660472,-13.8827496975339 61.1480502970943,-13.6055199369076 61.6667106990579,-13.2324314435597 62.1213203435589,-12.7778217990588 62.4944088369069,-12.2591613970953 62.7716385975333,-11.6963820660484 62.9423558412091,-11.1111111 62.9999999999994,-10.5258401339516 62.9423558412091,-9.96306080290474 62.7716385975333,-9.4444004009412 62.4944088369069,-8.98979075644036 62.1213203435589,-8.61670226309237 61.6667106990579,-8.33947250246614 61.1480502970943,-8.16875525879031 60.5852709660472,-8.1111111 59.9999999999987)) }}} In PostgreSQL 9.2.4, compiled by Visual C++ build 1600, 32-bit POSTGIS=""2.2.0dev r12228"" GEOS=""3.4.2-CAPI-1.8.2 r0"" PROJ=""Rel. 4.8.0, 6 March 2012"" GDAL=""GDAL 1.10.0, released 2013/04/24"" LIBXML=""2.7.8"" LIBJSON=""UNKNOWN"" RASTER (and also 2.1.1 release so assume case for current 2.1.2dev) {{{ POLYGON((-8.11111109999999 59.9999999984909,-8.16875525879032 59.4147290323908,-8.33947250246614 58.8519497012907,-8.61670226309236 58.333289299275,-8.98979075644036 57.8786796547257,-9.4444004009412 57.5055911613359,-9.96306080290472 57.2283614006773,-10.5258401339516 57.0576441569811,-11.1111111 56.9999999981838,-11.6963820660484 57.0576441569811,-12.2591613970953 57.2283614006773,-12.7778217990588 57.5055911613359,-13.2324314435596 57.8786796547257,-13.6055199369076 58.333289299275,-13.8827496975339 58.8519497012907,-14.0534669412097 59.4147290323908,-14.1111111 59.9999999984909,-14.0534669412097 60.5852709645878,-13.8827496975339 61.1480502956783,-13.6055199369076 61.6667106976798,-13.2324314435597 62.1213203422121,-12.7778217990588 62.494408835585,-12.2591613970953 62.7716385962291,-11.6963820660484 62.9423558399157,-11.1111111 62.9999999987096,-10.5258401339516 62.9423558399157,-9.96306080290473 62.7716385962291,-9.44440040094121 62.494408835585,-8.98979075644036 62.1213203422121,-8.61670226309236 61.6667106976797,-8.33947250246615 61.1480502956783,-8.16875525879031 60.5852709645878,-8.11111109999999 59.9999999984909)) }}} " defect closed medium PostGIS 2.1.2 postgis 2.1.x invalid