<div dir="ltr">Thanks for continuing to try stuff. What does this example return?<div><br></div><div>SELECT <br>ST_Relate(a.geom, b.geom), ST_Relate(a.geom, b.geom, '1FF00F212')<br>FROM <br>(VALUES ('LINESTRING (170 290, 205 272)'),('LINESTRING (120 215, 176 197)')) AS a(geom),<br>(VALUES ('POLYGON ((100 200, 140 230, 180 310, 280 310, 390 270, 400 210, 320 140, 215 141, 150 170, 100 200))')) AS b(geom);<br></div><div><br></div></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Wed, Oct 15, 2025 at 1:29 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 dir="ltr"><div>Dear Paul</div><div>here are the results with the new linestrings as you suggested</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;</div><div>-- 1 row</div><div><br></div><div>"id" "patternmatrix"<br>7 "1FF00F212"</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';</div><div>-- 4 rows</div><div>"id" "patternmatrix"<br>7 "1FF00F212"<br>8 "1FF00F212"<br>12 "1FF00F212"<br>13 "1FF00F212"</div><div><br></div><div>As you can see nothing has changed.</div><div><br></div><div>I was wondering which version of PostGIS (and on which platform) has been used for producing the material reported into the tutorial (which shows 2 rows as a correct result).</div><div><br></div><div>I understand that it is difficult to find the reason for different results on different platforms but this shouldn't happen otherwise users are confused.. and not sure about the correct results.</div><div><br></div><div>When in the near future I will upgrade to PostgreSQL 18 and PostGIS 3.6.0 I will try again the same two queries and let you know if the results will be the same or not.</div><div>Thanks for the time you have spent on this matter.</div><div><br></div><div>Antonio</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno mer 15 ott 2025 alle ore 22:03 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"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Oct 15, 2025 at 12:53 PM 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>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>
</blockquote></div></div>
</blockquote></div>