On Tue, Mar 30, 2021 at 4:37 AM Hanefi Onaldi <hanefi.ona...@microsoft.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 <jtc...@gmail.com> > Sent: 6 Ağustos 2020 Perşembe 16:14 > To: pgsql-hackers <pgsql-hack...@postgresql.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