<div dir="ltr">Hi all,<div>maybe this example is easier to understand.</div><div><br></div><div>I cannot explain why </div><div>intersection between 2 line geometry return point (this is not true)</div><div>

<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial">and </div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial">intersection between 2 same geometry transformed to <span style="color:rgb(46,46,46);font-family:"Lucida Grande",Verdana,Geneva,Arial,Helvetica,sans-serif;font-size:13.3333px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">WKT and then again to geometry return line (this is true)</span></div><br class="gmail-Apple-interchange-newline">

<br></div><div><br></div><div><div>WITH geom AS</div><div>(</div><div>SELECT</div><div><br></div><div>---- linestring geometry</div><div>'0102000020E610000002000000F1CB9E90EF5822400B08BFE04DB8464089928BE6E8582240A6DE39B92DB84640'::geometry(linestring,4326) as a0,</div><div>'0102000020E610000003000000F4CB9E90EF5822400808BFE04DB8464089928BE6E8582240A6DE39B92DB846408C928BE6E8582240A9DE39B92DB84640' ::geometry(linestring,4326) as b0,</div><div>---------</div><div><br></div><div>---- makegeometry from output coordinate of ST_AsText</div><div>ST_GeomFromText (ST_AsText('0102000020E610000002000000F1CB9E90EF5822400B08BFE04DB8464089928BE6E8582240A6DE39B92DB84640'::geometry(linestring,4326))) as a1,</div><div>ST_GeomFromText (ST_AsText('0102000020E610000003000000F4CB9E90EF5822400808BFE04DB8464089928BE6E8582240A6DE39B92DB846408C928BE6E8582240A9DE39B92DB84640'::geometry(linestring,4326))) as b1,</div><div>---------</div><div><br></div><div>---- get point coordinate from linestring geometry</div><div>ST_AsText('0102000020E610000002000000F1CB9E90EF5822400B08BFE04DB8464089928BE6E8582240A6DE39B92DB84640'::geometry(linestring,4326)) as a,</div><div>ST_AsText('0102000020E610000003000000F4CB9E90EF5822400808BFE04DB8464089928BE6E8582240A6DE39B92DB846408C928BE6E8582240A9DE39B92DB84640' ::geometry(linestring,4326) ) as b</div><div>----------</div><div>)</div><div><br></div><div><br></div><div>SELECT st_geometrytype(st_intersection(a0,b0)),st_geometrytype(st_intersection(a1,b1)),a,b</div><div>FROM geom</div></div><div><br></div><div>RETURN</div><div>"ST_Point";"ST_LineString";"LINESTRING(9.17370273531376 45.4398766453524,9.17365189031377 45.4388953716819)";"LINESTRING(9.17370273531376 45.4398766453524,9.17365189031377 45.4388953716819,9.17365189031377 45.4388953716819)"<br></div><div><br></div><div><br></div><div><br></div><div>

<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial">"POSTGIS="2.2.1 r14555" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 1.11.3, released 2015/09/16" LIBXML="2.9.3" LIBJSON="0.11.99" TOPOLOGY RASTER"<br></div><br class="gmail-Apple-interchange-newline">

<br></div><div><br></div><div>Thanks a lot</div><div>f</div><div><br></div><div><br></div><div class="gmail_extra"><br><div class="gmail_quote">2018-05-29 12:49 GMT+02:00 franco base <span dir="ltr"><<a href="mailto:frenk.calza@gmail.com" target="_blank">frenk.calza@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Thanks I undesrtand.<div>Infact</div><div><br></div><div>SELECT st_contains(b,a)  return true.</div><div><br></div><div><br></div><div>I still don't understand why</div><div><br></div><div>

<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial">SELECT  <span style="font-size:12.8px">st_intersection(a,b) return a line</span></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="font-size:12.8px">and </span></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="font-size:12.8px"><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">SELECT st_intersection(a,c) return a point</span></span></div>

and</div><div>

<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;font-size:12.8px;background-color:rgb(255,255,255)"><span style="font-size:12.8px"><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">SELECT st_intersection(b,c) return a point</span></span></div><br class="m_1891641188958642233gmail-Apple-interchange-newline">

<br></div><div><br></div><div>SELECT ST_AsText (c)<br></div><div><br></div><div>return</div><div><br></div><div>"LINESTRING(<b>9.18334214253396 45.4443310195606,9.<wbr>18284350788197 45.4441804010334,9.<wbr>18274220788201 45.4441483010334,9.<wbr>18274220788201 45.4441483010334,9.<wbr>18271080788202 45.4441388010335,9.<wbr>18271080788202 45.4441388010335</b>,9.<wbr>18267210788205 45.4442348010335,9.<wbr>18267210788205 45.4442348010335,9.<wbr>18256900788209 45.4442025010335,9.<wbr>18256930788208 45.4442020010335,9.<wbr>1817161078824 45.4439402010335,9.<wbr>1817161078824 45.4439402010335,9.<wbr>18096850788267 45.4437069010336,9.<wbr>18096850788267 45.4437069010336,9.<wbr>18075270788275 45.4436465010336,9.<wbr>18075270788275 45.4436465010336,9.<wbr>18046820788286 45.4435903010337,9.<wbr>18046820788286 45.4435903010337,9.<wbr>18017890788296 45.4435440010337,9.<wbr>18017890788296 45.4435440010337,9.<wbr>17996920788304 45.4435166010337,9.<wbr>17996920788304 45.4435166010337,9.<wbr>17973530788314 45.4435053010337,9.<wbr>17973530788314 45.4435053010337,9.<wbr>17950020788323 45.4435044010337,9.<wbr>17950020788323 45.4435044010337,9.<wbr>17913950788338 45.4435149010338,9.<wbr>17913950788338 45.4435149010338,9.<wbr>17903360788343 45.4435180010338,9.<wbr>17903360788343 45.4435180010338,9.<wbr>17900690788344 45.4435188010338,9.<wbr>17900690788344 45.4435188010338,9.<wbr>17898210788345 45.4435200010338,9.<wbr>17898210788345 45.4435200010338,9.<wbr>17890050788348 45.4435241010338,9.<wbr>17890050788348 45.4435241010338,9.<wbr>17876780788353 45.4435307010338,9.<wbr>17847140788366 45.4435455010338,9.<wbr>17875697558416 45.4435312419178)"<br></div><div><br></div><div>The first 6 point are the same that make b geometry</div><span class=""><div><br></div><div>

<span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">>> st_makepoint(9.18334214253396,</span><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><wbr>45.4443310195606),</span><br style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">>> st_makepoint(9.18284350788197,</span><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><wbr>45.4441804010334),</span><br style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">>> st_makepoint(9.18274220788201,</span><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><wbr>45.4441483010334),</span><br style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">>> st_makepoint(9.18274220788201,</span><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><wbr>45.4441483010334),</span><br style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">>> st_makepoint(9.18271080788202,</span><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><wbr>45.4441388010335),</span><br style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">>> st_makepoint(9.18271080788202,</span><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><wbr>45.4441388010335)</span>

<br></div><div class="gmail_extra"><br></div></span><div class="gmail_extra">

<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial">The first 2 point are the same that make a geometry</div>

<span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">>> st_makepoint(9.18284350788197,</span><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><wbr>45.4441804010334),</span><br style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">>> st_makepoint(9.18334214253396,</span><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><wbr>45.4443310195606)</span>

<br class="m_1891641188958642233gmail-Apple-interchange-newline">

<br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra">thanks</div><span class="HOEnZb"><font color="#888888"><div class="gmail_extra">f</div></font></span><div><div class="h5"><div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><br><div class="gmail_quote">2018-05-28 21:22 GMT+02:00 Paul Ramsey <span dir="ltr"><<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Also knowing that the end points of a line string are considered the<br>
boundary of the linestring, not the interior...<br>
<div class="m_1891641188958642233HOEnZb"><div class="m_1891641188958642233h5"><br>
On Mon, May 28, 2018 at 12:21 PM, Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>> wrote:<br>
> Does knowing that an overlaps test is only true if the interiors of<br>
> both objects interact, but there is no full containment relationship<br>
> help you understand a little?<br>
><br>
> On Mon, May 28, 2018 at 8:03 AM, franco base <<a href="mailto:frenk.calza@gmail.com" target="_blank">frenk.calza@gmail.com</a>> wrote:<br>
>> Hi all,<br>
>><br>
>><br>
>> question 1)<br>
>> why ST_Overlaps doesn't work with geometry a and b?<br>
>> The first 2 point of the 2 line (bold) are the same.<br>
>> ST_Intersection works<br>
>><br>
>> question 2)<br>
>> if I extend line b it becomes c<br>
>> (sorry i write text geometry because I have a lot of point coord),<br>
>> ST_Overlaps return false and also<br>
>> ST_Intersection return a point (length =0)<br>
>><br>
>> What's happen?<br>
>><br>
>> "POSTGIS="2.2.1 r14555" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.2, 08<br>
>> September 2015" GDAL="GDAL 1.11.3, released 2015/09/16" LIBXML="2.9.3"<br>
>> LIBJSON="0.11.99" TOPOLOGY RASTER"<br>
>><br>
>><br>
>> WITH geom AS<br>
>> (<br>
>> SELECT<br>
>> st_setsrid(st_makeline(<br>
>> st_makepoint(9.18284350788197,<wbr>45.4441804010334),<br>
>> st_makepoint(9.18334214253396,<wbr>45.4443310195606)<br>
>> ),4326) a,<br>
>><br>
>> st_setsrid(st_makeline(ARRAY[<br>
>> st_makepoint(9.18334214253396,<wbr>45.4443310195606),<br>
>> st_makepoint(9.18284350788197,<wbr>45.4441804010334),<br>
>> st_makepoint(9.18274220788201,<wbr>45.4441483010334),<br>
>> st_makepoint(9.18274220788201,<wbr>45.4441483010334),<br>
>> st_makepoint(9.18271080788202,<wbr>45.4441388010335),<br>
>> st_makepoint(9.18271080788202,<wbr>45.4441388010335) ]),4326) b,<br>
>><br>
>> '0102000020E610000027000000E85<wbr>27405DF5D224039CEBED6DFB846402<wbr>A470DAA9D5D22403CFB43E7DAB8464<wbr>073E7FC62905D22409DC1FDD9D9B84<wbr>64073E7FC62905D22409DC1FDD9D9B<wbr>8464040F560458C5D224065A94C8AD<wbr>9B8464040F560458C5D224065A94C8<wbr>AD9B84640577DD232875D224085179<wbr>BAFDCB84640577DD232875D2240851<wbr>79BAFDCB84640C43B5CAF795D2240B<wbr>B5EA7A0DBB84640BB366DB9795D224<wbr>0D5A0759CDBB84640CB05C9E4095D2<wbr>240CC685208D3B84640CB05C9E4095<wbr>D2240CC685208D3B8464088EC7DE7A<wbr>75C224074794263CBB8464088EC7DE<wbr>7A75C224074794263CBB84640280A7<wbr>29E8B5C224050769668C9B84640280<wbr>A729E8B5C224050769668C9B846403<wbr>1A63554665C224097E12591C7B8464<wbr>031A63554665C224097E12591C7B84<wbr>6409A92E968405C22406A63C10CC6B<wbr>846409A92E968405C22406A63C10CC<wbr>6B84640164A8CEC245C22402356E82<wbr>6C5B84640164A8CEC245C22402356E<wbr>826C5B84640D4962A44065C22406FC<wbr>51DC8C4B84640D4962A44065C22406<wbr>FC51DC8C4B84640A5F78473E75B224<wbr>0380991C0C4B84640A5F78473E75B2<wbr>240380991C0C4B84640B08F6F2CB85<wbr>B2240449DA518C5B84640B08F6F2CB<wbr>85B2240449DA518C5B84640087D054<wbr>BAA5B224050D0A632C5B84640087D0<wbr>54BAA5B224050D0A632C5B84640213<wbr>C1ECBA65B2240F2CC5C39C5B846402<wbr>13C1ECBA65B2240F2CC5C39C5B8464<wbr>06BDBF78AA35B2240F0C76D43C5B84<wbr>6406BDBF78AA35B2240F0C76D43C5B<wbr>84640D731EDD8985B2240C676D265C<wbr>5B84640D731EDD8985B2240C676D26<wbr>5C5B84640EFDF4074875B224027DB2<wbr>F9DC5B846404443B89A605B2240369<wbr>D5619C6B84640B521C808865B22404<wbr>765B9A1C5B84640'::geometry<br>
>> as c<br>
>> )<br>
>><br>
>><br>
>> SELECT<br>
>> ---- question 1<br>
>> st_overlaps(a,b),<br>
>> st_length(st_intersection(a,b)<wbr>::geography)::int,<br>
>> ---- question 2<br>
>> st_overlaps(a,c),<br>
>> st_length(st_intersection(a,c)<wbr>::geography)::int<br>
>><br>
>> FROM geom<br>
>><br>
>><br>
>> return<br>
>><br>
>> f;42;f;0<br>
>><br>
>><br>
>><br>
>> thanks<br>
>> ft<br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>> ______________________________<wbr>_________________<br>
>> postgis-users mailing list<br>
>> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
>> <a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/postgis-users</a><br>
______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/postgis-users</a></div></div></blockquote></div><br></div></div></div></div>
</blockquote></div><br></div></div>