---------- Forwarded message ---------
From: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
Date: Mon, 4 Apr 2022 at 23:13
Subject: How to just get the last in a recursive query
To: PostGIS Users Discussion <postgis-users(at)lists(dot)osgeo(dot)org>
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