<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Wed, Oct 15, 2025 at 12:53 PM Antonio Valanzano <<a href="mailto:anvalanz@gmail.com">anvalanz@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Hi Paul</div><div>I have upgraded to PosGIS 3.5.3 and GEOS
3.13.1 as you can see from the following output </div><div><br></div><div>"postgis_full_version"<br>"POSTGIS=""3.5.3 3.5.3"" [EXTENSION] PGSQL=""170"" GEOS=""3.13.1-CAPI-1.19.2"" PROJ=""8.2.1 NETWORK_ENABLED=OFF URL_ENDPOINT=<a href="https://cdn.proj.org" target="_blank">https://cdn.proj.org</a> USER_WRITABLE_DIRECTORY=C:\Windows\ServiceProfiles\NetworkService\AppData\Local/proj DATABASE_PATH=C:\Program Files\PostgreSQL\17\share\contrib\postgis-3.5\proj\proj.db"" (compiled against PROJ 8.2.1) LIBXML=""2.12.5"" LIBJSON=""0.12"" LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0 (Internal)"" (core procs from ""3.5.2 3.5.2"" need upgrade)"<br><br></div><div>but the results are the same with one row for a query and 2 rows for the other query.</div><div><br></div><div>Is this a known bug or no other user has already reported this behaviour ?</div></div></blockquote><div><br></div><div>Not reported, and I'm afraid not solvable unless you can figure out the specific thing about your install vs mine that is giving you a different answer. (Windows is one possibility, though not one I particularly like, platform differences are incredibly hard to isolate.) </div><div><br></div><div>Seeing if the problem is ordering based and number of entries based might be interesting. </div><div><br></div><div>DELETE FROM docsk;</div><div>INSERT INTO docks ( geom, good )<br> VALUES<br> ('LINESTRING (170 290, 205 272)',true),<br> ('LINESTRING (120 215, 176 197)',true),<br> ('LINESTRING (290 260, 340 250)',false),<br> ('LINESTRING (350 300, 400 320)',false),<br> ('LINESTRING (370 230, 420 240)',false),<br> ('LINESTRING (170 290, 205 272)',true),<br> ('LINESTRING (120 215, 176 197)',true),<br> ('LINESTRING (370 180, 390 160)',false);<br></div><div><br></div><div>P </div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><br></div><div>Antonio</div><div><br></div><div><br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno mer 15 ott 2025 alle ore 20:59 Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir="ltr">Sorry, I still cannot replicate. My 3.5 build still returns both results. Maybe update to PostGIS 3.5.4 and GEOS 3.13.1 ?<div>P.</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Oct 15, 2025 at 11:25 AM Antonio Valanzano <<a href="mailto:anvalanz@gmail.com" target="_blank">anvalanz@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Here is the details of my installation:</div><div><br></div><div>"postgis_full_version"<br>"POSTGIS=""3.5.2 3.5.2"" [EXTENSION] PGSQL=""170"" GEOS=""3.13.0-CAPI-1.19.0"" PROJ=""8.2.1 NETWORK_ENABLED=OFF URL_ENDPOINT=<a href="https://cdn.proj.org" target="_blank">https://cdn.proj.org</a> USER_WRITABLE_DIRECTORY=C:\Windows\ServiceProfiles\NetworkService\AppData\Local/proj DATABASE_PATH=C:\Program Files\PostgreSQL\17\share\contrib\postgis-3.5\proj\proj.db"" (compiled against PROJ 8.2.1) LIBXML=""2.12.5"" LIBJSON=""0.12"" LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0 (Internal)"""</div><div><br></div><div>Antonio</div><div><br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno mer 15 ott 2025 alle ore 19:28 Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir="ltr">Maybe you have found an old bug? Running exactly the same SQL as you, I get two rows from each query.<div><font face="monospace"><br></font></div><div><font face="monospace">postgis=# SELECT <a href="http://d.id" target="_blank">d.id</a>, ST_Relate(d.geom, l.geom) as patternMatrix FROM docks as d, lakes as l WHERE ST_Relate(d.geom, l.geom, '1FF00F212');<br> id | patternmatrix <br>----+---------------<br> 1 | 1FF00F212<br> 2 | 1FF00F212<br>(2 rows)<br><br>postgis=# SELECT<br>postgis-# <a href="http://d.id" target="_blank">d.id</a>,<br>postgis-# ST_Relate(d.geom, l.geom) as patternMatrix<br>postgis-# FROM docks as d, lakes as l<br>postgis-# WHERE ST_Relate(d.geom, l.geom) = '1FF00F212';<br> id | patternmatrix <br>----+---------------<br> 1 | 1FF00F212<br> 2 | 1FF00F212<br>(2 rows)<br><br>postgis=# <br>postgis=# select postgis_full_version();<br> postgis_full_version <br>----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br> POSTGIS="3.7.0dev 3.6.0rc2-134-g5dc95f1bc" [EXTENSION] PGSQL="180" GEOS="3.15.0dev-CAPI-1.21.0" PROJ="9.6.2 NETWORK_ENABLED=ON URL_ENDPOINT=<a href="https://cdn.proj.org" target="_blank">https://cdn.proj.org</a> USER_WRITABLE_DIRECTORY=/Users/pramsey/Library/Application Support/proj DATABASE_PATH=/opt/homebrew/Cellar/proj/9.6.2/share/proj/proj.db" (compiled against PROJ 9.6.2) LIBXML="2.9.13" LIBJSON="0.18" LIBPROTOBUF="1.5.2" WAGYU="0.5.0 (Internal)" (core procs from "3.7.0dev 3.6.0rc2-125-g747d7732b" need upgrade)</font><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Oct 15, 2025 at 9:22 AM Antonio Valanzano <<a href="mailto:anvalanz@gmail.com" target="_blank">anvalanz@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>I am fo<font size="2">llowing the "Introduction to PostGIS " tutorial at <a href="https://postgis.net/workshops/postgis-intro/" target="_blank">https://postgis.net/workshops/postgis-intro/</a></font></div><div><font size="2">and for chapter 26 "</font><span style="font-weight:normal"><font size="2">Dimensionally Extended 9-Intersection Model</font></span>" I am trying to replicate the examples.</div><div><br></div><div>If I use the two different versions of ST_Relate I do not obtain the same result</div><div><br></div><div>SELECT<br> <a href="http://d.id" target="_blank">d.id</a>, <br> ST_Relate(d.geom, l.geom) as patternMatrix<br>FROM docks as d, lakes as l<br>WHERE ST_Relate(d.geom, l.geom, '1FF00F212') = true;<br>-- 1 row<br>"id" "patternmatrix"<br>1 "1FF00F212"<br><br><br><br>SELECT<br> <a href="http://d.id" target="_blank">d.id</a>, <br> ST_Relate(d.geom, l.geom) as patternMatrix<br>FROM docks as d, lakes as l<br>WHERE ST_Relate(d.geom, l.geom) = '1FF00F212';<br>-- 2 rows<br>"id" "patternmatrix"<br>1 "1FF00F212"<br>2 "1FF00F212"</div><div><br></div><div>Could someone give me an explanation of such a difference ?</div><div><br></div><div><br></div><div> </div><div> </div></div>
</blockquote></div>
</blockquote></div>
</blockquote></div>
</blockquote></div>
</blockquote></div></div>