<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">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><br></div><div>Antonio</div><div><br></div><div><br></div><div><br></div></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">Il giorno mer 15 ott 2025 alle ore 20:59 Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca">pramsey@cleverelephant.ca</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid 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:1px solid 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:1px solid 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:1px solid 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>