<div dir="ltr"><div>Actually 3.6.0 already has the fix, so only the stable 3.5 branch in conjunction with GEOS 3.13+ with display the issue.</div><div><br></div><div>P.</div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Thu, Oct 16, 2025 at 9:25 AM Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca">pramsey@cleverelephant.ca</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">Arg, found it. How old am I? Old enough not to remember this fix from, not YEARS ago, but only months ago.<div><br></div><div><a href="https://trac.osgeo.org/postgis/ticket/5938" target="_blank">https://trac.osgeo.org/postgis/ticket/5938</a><br></div><div><br></div><div>The interaction between the new "cacheable relate" code and the need for stable operand order for the relate pattern match function generates these issues, and it's not platform specific, just version specific. Unfortunately the version of PostGIS 3.5 that fixes this issue... is not yet released. 3.5.4 will include this fix. As will 3.6.1. My habit of running and testing off the latest stable branch bit me here, if I was testing your exact release I would have seen the error immediately.</div><div><br></div><div>P.</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Oct 15, 2025 at 8:25 PM Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</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><div lang="EN-US"><div><p class="MsoNormal">Antonio,<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">I can replicate your issue with PG17 on windows<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">--------------------------------------------------------------<u></u><u></u></p><p class="MsoNormal"> 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= USER_WRITABLE_DIRECTORY=C:\Windows\ServiceProfiles\NetworkService\AppData\Local/proj" (compiled against PROJ 8.2.1) LIBXML="2.12.5<u></u><u></u></p><p class="MsoNormal">" LIBJSON="0.12" LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)"<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">However the PG18 3.6.0 windows package behaves correctly:<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">PG18 3.6.0 - POSTGIS="3.6.0 3.6.0" [EXTENSION] PGSQL="180" GEOS="3.14.0-CAPI-1.20.4" SFCGAL="SFCGAL 2.2.0, CGAL 6.0.1, BOOST 1.88.0" PROJ="8.2.1 NETWORK_ENABLED=OFF URL_ENDPOINT= USER_WRITABLE_DIRECTORY=C:\Users\Administrator\AppData\Local/proj" (compiled again<br>st PROJ 8.2.1) GDAL="GDAL 3.9.2, released 2024/08/13 GDAL_DATA not found" LIBXML="2.12.5" LIBJSON="0.12" LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)" TOPOLOGY RASTER<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">There are many things changed between the building of the windows 3.5.3 and the 3.6.0 packages<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">e.g. the GEOS was upgraded, I’m compiling with a newer GCC version , and of course PostGIS is newer.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">I’m planning to release PostGIS 3.6.1 for PostgreSQL 17, but skipping PostGIS 3.6.0 since I have some minor packaging issues to address first and PostGIS 3.6.1 is probably less than a month away.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">But we’ll try to figure out what piece is the culprit here.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><div style="border-width:medium medium medium 1.5pt;border-style:none none none solid;border-color:currentcolor currentcolor currentcolor blue;padding:0in 0in 0in 4pt"><div><div style="border-width:1pt medium medium;border-style:solid none none;border-color:rgb(225,225,225) currentcolor currentcolor;padding:3pt 0in 0in"><p class="MsoNormal"><b><span style="font-size:11pt;font-family:Calibri,sans-serif">From:</span></b><span style="font-size:11pt;font-family:Calibri,sans-serif"> Paul Ramsey via postgis-users <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>> <br><b>Sent:</b> Wednesday, October 15, 2025 6:32 PM<br><b>To:</b> Antonio Valanzano <<a href="mailto:anvalanz@gmail.com" target="_blank">anvalanz@gmail.com</a>><br><b>Cc:</b> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><b>Subject:</b> Re: different results for ST_Relate with 3 parameters compared to those for ST_Relate with 2 parameters<u></u><u></u></span></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal">One more sorry!<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">SELECT <br>ST_Relate(a.geom, b.geom), ST_Relate(a.geom, b.geom, '1FF00F212')<br>FROM <br>(VALUES <br> ('LINESTRING (170 290, 205 272)'),<br> ('LINESTRING (120 215, 176 197)'),<br> ('LINESTRING (170 290, 205 272)'),<br> ('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);<u></u><u></u></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">On Wed, Oct 15, 2025 at 3:11<span style="font-family:Arial,sans-serif"> </span>PM Antonio Valanzano <<a href="mailto:anvalanz@gmail.com" target="_blank">anvalanz@gmail.com</a>> wrote:<u></u><u></u></p></div><blockquote style="border-width:medium medium medium 1pt;border-style:none none none solid;border-color:currentcolor currentcolor currentcolor rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"><div><div><p class="MsoNormal">Here are the results <u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">SELECT<br> ST_Relate(a.geom, b.geom), <br> 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>-- 2 rows<br>"st_relate" "st_relate-2"<br>"1FF00F212" true<br>"1FF00F212" false<u></u><u></u></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">Il giorno mer 15 ott 2025 alle ore 23:22 Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>> ha scritto:<u></u><u></u></p></div><blockquote style="border-width:medium medium medium 1pt;border-style:none none none solid;border-color:currentcolor currentcolor currentcolor rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"><div><p class="MsoNormal">Thanks for continuing to try stuff. What does this example return?<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">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);<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">On Wed, Oct 15, 2025 at 1:29<span style="font-family:Arial,sans-serif"> </span>PM Antonio Valanzano <<a href="mailto:anvalanz@gmail.com" target="_blank">anvalanz@gmail.com</a>> wrote:<u></u><u></u></p></div><blockquote style="border-width:medium medium medium 1pt;border-style:none none none solid;border-color:currentcolor currentcolor currentcolor rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"><div><div><div><p class="MsoNormal">Dear Paul<u></u><u></u></p></div><div><p class="MsoNormal">here are the results with the new linestrings as you suggested<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">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;<u></u><u></u></p></div><div><p class="MsoNormal">-- 1 row<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">"id" "patternmatrix"<br>7 "1FF00F212"<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">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';<u></u><u></u></p></div><div><p class="MsoNormal">-- 4 rows<u></u><u></u></p></div><div><p class="MsoNormal">"id" "patternmatrix"<br>7 "1FF00F212"<br>8 "1FF00F212"<br>12 "1FF00F212"<br>13 "1FF00F212"<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">As you can see nothing has changed.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">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).<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">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.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">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.<u></u><u></u></p></div><div><p class="MsoNormal">Thanks for the time you have spent on this matter.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Antonio<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">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:<u></u><u></u></p></div><blockquote style="border-width:medium medium medium 1pt;border-style:none none none solid;border-color:currentcolor currentcolor currentcolor rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"><div><div><p class="MsoNormal"><u></u> <u></u></p></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">On Wed, Oct 15, 2025 at 12:53<span style="font-family:Arial,sans-serif"> </span>PM Antonio Valanzano <<a href="mailto:anvalanz@gmail.com" target="_blank">anvalanz@gmail.com</a>> wrote:<u></u><u></u></p></div><blockquote style="border-width:medium medium medium 1pt;border-style:none none none solid;border-color:currentcolor currentcolor currentcolor rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"><div><div><p class="MsoNormal">Hi Paul<u></u><u></u></p></div><div><p class="MsoNormal">I have upgraded to PosGIS 3.5.3 and GEOS 3.13.1 as you can see from the following output <u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal" style="margin-bottom:12pt">"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)"<u></u><u></u></p></div><div><p class="MsoNormal">but the results are the same with one row for a query and 2 rows for the other query.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Is this a known bug or no other user has already reported this behaviour ?<u></u><u></u></p></div></div></blockquote><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">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.) <u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Seeing if the problem is ordering based and number of entries based might be interesting. <u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">DELETE FROM docsk;<u></u><u></u></p></div><div><p class="MsoNormal">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);<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">P <u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><blockquote style="border-width:medium medium medium 1pt;border-style:none none none solid;border-color:currentcolor currentcolor currentcolor rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"><div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Antonio<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">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:<u></u><u></u></p></div><blockquote style="border-width:medium medium medium 1pt;border-style:none none none solid;border-color:currentcolor currentcolor currentcolor rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"><div><p class="MsoNormal">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 ?<u></u><u></u></p><div><p class="MsoNormal">P.<u></u><u></u></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">On Wed, Oct 15, 2025 at 11:25<span style="font-family:Arial,sans-serif"> </span>AM Antonio Valanzano <<a href="mailto:anvalanz@gmail.com" target="_blank">anvalanz@gmail.com</a>> wrote:<u></u><u></u></p></div><blockquote style="border-width:medium medium medium 1pt;border-style:none none none solid;border-color:currentcolor currentcolor currentcolor rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"><div><div><p class="MsoNormal">Here is the details of my installation:<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">"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)"""<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Antonio<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">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:<u></u><u></u></p></div><blockquote style="border-width:medium medium medium 1pt;border-style:none none none solid;border-color:currentcolor currentcolor currentcolor rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"><div><p class="MsoNormal">Maybe you have found an old bug? Running exactly the same SQL as you, I get two rows from each query.<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><span style="font-family:"Courier New"">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)</span><u></u><u></u></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">On Wed, Oct 15, 2025 at 9:22<span style="font-family:Arial,sans-serif"> </span>AM Antonio Valanzano <<a href="mailto:anvalanz@gmail.com" target="_blank">anvalanz@gmail.com</a>> wrote:<u></u><u></u></p></div><blockquote style="border-width:medium medium medium 1pt;border-style:none none none solid;border-color:currentcolor currentcolor currentcolor rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"><div><div><p class="MsoNormal">I am fo<span style="font-size:10pt">llowing the "Introduction to PostGIS " tutorial at <a href="https://postgis.net/workshops/postgis-intro/" target="_blank">https://postgis.net/workshops/postgis-intro/</a></span><u></u><u></u></p></div><div><p class="MsoNormal"><span style="font-size:10pt">and for chapter 26 "Dimensionally Extended 9-Intersection Model</span>" I am trying to replicate the examples.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">If I use the two different versions of ST_Relate I do not obtain the same result<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">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"<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Could someone give me an explanation of such a difference ?<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div></div></blockquote></div></blockquote></div></blockquote></div></blockquote></div></blockquote></div></div></blockquote></div></div></blockquote></div></blockquote></div></blockquote></div></div></div></div></div></blockquote></div>
</blockquote></div></div>