Re: How to just get the last in a recursive query
| От | Shaozhong SHI |
|---|---|
| Тема | Re: How to just get the last in a recursive query |
| Дата | |
| Msg-id | CA+i5JwZR_XYcbU_bekoAo1rAE=6+X+je_7+4+repLztLZqxoHg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: How to just get the last in a recursive query (Rob Sargent <robjsargent@gmail.com>) |
| Ответы |
Re: How to just get the last in a recursive query
Re: How to just get the last in a recursive query RE: How to just get the last in a recursive query |
| Список | pgsql-sql |
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 Monday, 4 April 2022, Rob Sargent <robjsargent@gmail.com> wrote:
On 4/4/22 16:14, Shaozhong SHI wrote:reverse the order of the last query and set limit 1---------- 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 1How to just get the last (namely, 1) in the most efficient way?Regards, David
В списке pgsql-sql по дате отправления: