MIME-Version: 1.0
In-Reply-To: <4e60ede0-86a5-4900-b415-05d68ad75cb1@Spark>
References: <3ed0759d-c332-4f96-a147-499a694e9204@Spark> <56c4c567-8422-4944-81d1-2a3c2ac5c8fa@ewie.name>
 <4e60ede0-86a5-4900-b415-05d68ad75cb1@Spark>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Mon, 4 Nov 2024 16:44:24 -0700
Message-ID: <CAKFQuwZH2C=itB7h=S+0UiG5k=U4PsdaLKxsWenZ7GWFdAsDxA@mail.gmail.com>
Subject: Re: nth_value out of more than n values returns null
To: Guyren Howe <guyren@gmail.com>
Cc: Erik Wienhold <ewie@ewie.name>, PG-General Mailing List <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000056363606261edd40"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZH2C%3DitB7h%3DS%2B0UiG5k%3DU4PsdaLKxsWenZ7GWFdAsDxA%40mail.gmail.com>
Precedence: bulk

--00000000000056363606261edd40
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Monday, November 4, 2024, Guyren Howe <guyren@gmail.com> wrote:

> I=E2=80=99m trying to get the id of the 5,000,000th record, so I can join=
 against
> it to get a name. I didn=E2=80=99t fully understand what the docs say the=
re. What
> am I missing?
>

So just use =E2=80=9Coffset 5_000_000 limit 1=E2=80=9D.  Bringing in a wind=
ow function here
seems unhelpful.

David J.

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

On Monday, November 4, 2024, Guyren Howe &lt;<a href=3D"mailto:guyren@gmail=
.com">guyren@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail_quote" =
style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">


<div>
<div name=3D"messageBodySection">
<div dir=3D"auto">I=E2=80=99m trying to get the id of the 5,000,000th recor=
d, so I can join against it to get a name. I didn=E2=80=99t fully understan=
d what the docs say there. What am I missing?</div></div></div></blockquote=
><div><br></div><div>So just use =E2=80=9Coffset 5_000_000 limit 1=E2=80=9D=
.=C2=A0 Bringing in a window function here seems unhelpful.</div><div><br><=
/div><div>David J.</div><div><br></div>

--00000000000056363606261edd40--