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 3817c56b-458d-5295-e8bc-1001231dc5c8@gmail.com
Whole thread Raw
In response to How to just get the last in a recursive query  (Shaozhong SHI <shishaozhong@gmail.com>)
Responses 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 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

pgsql-sql by date:

Previous
From: Shaozhong SHI
Date:
Subject: How to just get the last in a recursive query
Next
From: Shaozhong SHI
Date:
Subject: Re: How to just get the last in a recursive query