MIME-Version: 1.0
References: 
 <CA+i5JwbAz1nO_yVtfBfDeJwk8NmEQ_8bC15cOEMyc_j_Zi70Jg@mail.gmail.com>
 <CA+i5Jwbh6Yy-zW3AX3WLCUJANky9w8HtVo99NPxMAc9APY0zhw@mail.gmail.com>
 <3817c56b-458d-5295-e8bc-1001231dc5c8@gmail.com>
 <CA+i5JwZR_XYcbU_bekoAo1rAE=6+X+je_7+4+repLztLZqxoHg@mail.gmail.com>
In-Reply-To: 
 <CA+i5JwZR_XYcbU_bekoAo1rAE=6+X+je_7+4+repLztLZqxoHg@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Mon, 4 Apr 2022 16:32:12 -0700
Message-ID: 
 <CAKFQuwZU1mex4t8JGz2DKJZ4cLf25w4vY9fDAJCYtJcpezWnbQ@mail.gmail.com>
Subject: Re: How to just get the last in a recursive query
To: Shaozhong SHI <shishaozhong@gmail.com>
Cc: Rob Sargent <robjsargent@gmail.com>,
 pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005a3a2d05dbdc8a6b"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwZU1mex4t8JGz2DKJZ4cLf25w4vY9fDAJCYtJcpezWnbQ%40mail.gmail.com>
Precedence: bulk

--0000000000005a3a2d05dbdc8a6b
Content-Type: text/plain; charset="UTF-8"

On Mon, Apr 4, 2022, 16:21 Shaozhong SHI <shishaozhong@gmail.com> wrote:

> That is not the most efficient in this case.


Can you prove that statement?  Provide a query that is more efficient.

David J.

--0000000000005a3a2d05dbdc8a6b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div class=3D"gmail_quote" dir=3D"auto"><div dir=3D"ltr" =
class=3D"gmail_attr">On Mon, Apr 4, 2022, 16:21 Shaozhong SHI &lt;<a href=
=3D"mailto:shishaozhong@gmail.com">shishaozhong@gmail.com</a>&gt; wrote:<br=
></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-=
left:1px #ccc solid;padding-left:1ex">That is not the most efficient in thi=
s case.</blockquote></div><div dir=3D"auto"><br></div><div dir=3D"auto">Can=
 you prove that statement?=C2=A0 Provide a query that is more efficient.</d=
iv><div dir=3D"auto"><br></div><div dir=3D"auto">David J.</div></div>

--0000000000005a3a2d05dbdc8a6b--