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

That is not the most efficient in this case.

How to tell query to deliberately miss out all except the last one is of interest.

Regards, David

On Monday, 4 April 2022, Rob Sargent <robjsargent@gmail.com> wrote:

On 4/4/22 16:14, Shaozhong SHI wrote:

---------- 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

reverse the order of the last query and set limit 1