Postgres Pro
Downloads
Home   >   mailing lists

Re: How to just get the last in a recursive query - Mailing list pgsql-sql

From Rob Sargent
Subject Re: How to just get the last in a recursive query
Date
Msg-id 524d8959-47c1-4ea7-92cf-8c946f56b428@gmail.com
Whole thread Raw
In response to Re: How to just get the last in a recursive query  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-sql
Tree view
On 4/4/22 17:21, Shaozhong SHI wrote:
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>



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
Don't top post

And your definition of "last" is what, exactly

pgsql-sql by date:

Previous
From: Shaozhong SHI
Date:
Subject: Re: How to just get the last in a recursive query
Next
From: "David G. Johnston"
Date:
Subject: Re: How to just get the last in a recursive query