On 4/4/22 16:14, Shaozhong SHI wrote:
>
>
> ---------- 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
reverse the order of the last query and set limit 1