Search Postgresql Archives

Re: nth_value out of more than n values returns null

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: nth_value out of more than n values returns null
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Mon, 4 Nov 2024 16:44:24 -0700
Cc: Erik Wienhold <ewie@xxxxxxxxx>, PG-General Mailing List <pgsql-general@xxxxxxxxxxxxxx>
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>

On Monday, November 4, 2024, Guyren Howe <guyren@xxxxxxxxx> wrote:

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

So just use “offset 5_000_000 limit 1”. Bringing in a window function here seems unhelpful.

David J.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: nth_value out of more than n values returns null
  - From: Tom Lane
- Re: nth_value out of more than n values returns null
  - From: Guyren Howe

References:
- nth_value out of more than n values returns null
  - From: Guyren Howe
- Re: nth_value out of more than n values returns null
  - From: Erik Wienhold
- Re: nth_value out of more than n values returns null
  - From: Guyren Howe

Prev by Date: Re: nth_value out of more than n values returns null
Next by Date: Re: nth_value out of more than n values returns null
Previous by thread: Re: nth_value out of more than n values returns null
Next by thread: Re: nth_value out of more than n values returns null
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux