[postgis-users] How to just get the last in a recursive query

[Shaozhong SHI]

In this example, Network Walking in PostGIS · 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220404/c99e9757/attachment.html>