Re: [EXTERNAL] Any objection to documenting pg_sequence_last_value()?

On Tue, Mar 30, 2021 at 4:37 AM Hanefi Onaldi
<Hanefi(dot)Onaldi(at)microsoft(dot)com> wrote:
>
> Hi All,
>
> I recently used pg_sequence_last_value() when working on a feature in an extension, and it would have been easier for me if there were some documentation for this function.
>
> I'd like to help document this function if there are no objections.
>
> Best,
> Hanefi
>
> -----Original Message-----
> From: James Coleman <jtc331(at)gmail(dot)com>
> Sent: 6 Ağustos 2020 Perşembe 16:14
> To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
> Subject: [EXTERNAL] Any objection to documenting pg_sequence_last_value()?
>
> The function pg_sequence_last_value() was added to underlie the pg_sequences view, and it's the only way I'm aware of from userspace to directly get the last value of a sequence globally (i.e., not within the current session like currval()/lastval()). Obviously you can join to the pg_sequences view, but that's sometimes unnecessarily cumbersome since it doesn't expose the relid of the sequence.
>
> When that function got added it apparently wasn't added to the docs, though I'm not sure if that was intentional or not.
>
> Does anyone have any objections to documenting
> pg_sequence_last_value() in the sequence manipulation functions doc page?
>
> James
>
>

Given there's been no objection, I think it'd be worth submitting a
patch (and I'd be happy to review if you're willing to author one).

James