Re: How to just get the last in a recursive query

---------- Forwarded message ---------
From: Shaozhong SHI <shishaozhong@gmail.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@lists.osgeo.org>

In this example, Network Walking in PostGIS · Paul Ramsey (cleverelephant.ca)

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