[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] How to just get the last in a recursive query
From:       Shaozhong SHI <shishaozhong () gmail ! com>
Date:       2022-04-04 22:13:50
Message-ID: CA+i5JwbAz1nO_yVtfBfDeJwk8NmEQ_8bC15cOEMyc_j_Zi70Jg () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


In this example, Network Walking in PostGIS =C2=B7 Paul Ramsey
(cleverelephant.ca)
<http://blog.cleverelephant.ca/2010/07/network-walking-in-postgis.html>

3 rows got returns as follows:

 id
---
  6
  3
  1


How to just get the last (namely, 1) in the most efficient way?

Regards, David

[Attachment #5 (text/html)]

<div dir="ltr"><div dir="ltr"><div dir="ltr">In this example,  <a \
href="http://blog.cleverelephant.ca/2010/07/network-walking-in-postgis.html">Network \
Walking in PostGIS  · Paul Ramsey (cleverelephant.ca)</a></div><div \
dir="ltr"><br></div><div>3 rows got returns as follows:</div><div><br></div><div><pre \
class="gmail-highlight" \
style="box-sizing:border-box;font-family:Menlo,Monaco,&quot;Courier \
New&quot;,monospace;margin-top:0px;margin-bottom:0px;padding:1rem;font-size:0.8rem;lin \
e-height:1.4;white-space:pre-wrap;word-break:break-all;background-color:rgb(249,249,249);border-radius:4px;color:rgb(81,81,81)"><code \
style="box-sizing:border-box;font-family:Menlo,Monaco,&quot;Courier \
New&quot;,monospace;padding:0px;font-size:16px;color:inherit;background-color:transparent;border-radius:3px"> \
                id
---
  6
  3
  1</code></pre><pre class="gmail-highlight" \
style="box-sizing:border-box;font-family:Menlo,Monaco,&quot;Courier \
New&quot;,monospace;margin-top:0px;margin-bottom:0px;padding:1rem;font-size:0.8rem;lin \
e-height:1.4;white-space:pre-wrap;word-break:break-all;background-color:rgb(249,249,249);border-radius:4px;color:rgb(81,81,81)"><code \
style="box-sizing:border-box;font-family:Menlo,Monaco,&quot;Courier \
New&quot;,monospace;padding:0px;font-size:16px;color:inherit;background-color:transparent;border-radius:3px"><br></code></pre><pre \
class="gmail-highlight" \
style="box-sizing:border-box;font-family:Menlo,Monaco,&quot;Courier \
New&quot;,monospace;margin-top:0px;margin-bottom:0px;padding:1rem;font-size:0.8rem;lin \
e-height:1.4;white-space:pre-wrap;word-break:break-all;background-color:rgb(249,249,249);border-radius:4px;color:rgb(81,81,81)"><code \
style="box-sizing:border-box;font-family:Menlo,Monaco,&quot;Courier \
New&quot;,monospace;padding:0px;font-size:16px;color:inherit;background-color:transparent;border-radius:3px">How \
to just get the last (namely, 1) in the most efficient way?</code></pre><pre \
class="gmail-highlight" \
style="box-sizing:border-box;font-family:Menlo,Monaco,&quot;Courier \
New&quot;,monospace;margin-top:0px;margin-bottom:0px;padding:1rem;font-size:0.8rem;lin \
e-height:1.4;white-space:pre-wrap;word-break:break-all;background-color:rgb(249,249,249);border-radius:4px;color:rgb(81,81,81)">Regards, \
David</pre></div></div></div>



_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]