pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedhttps://www.postgresql.org/docs/current/functions-sequence.html
3+ messages / 3 participants
[nested] [flat]
* https://www.postgresql.org/docs/current/functions-sequence.html
@ 2020-10-19 19:31 PG Doc comments form <noreply@postgresql.org>
2020-10-19 20:52 ` Re: https://www.postgresql.org/docs/current/functions-sequence.html David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: PG Doc comments form @ 2020-10-19 19:31 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: rogerpack2005@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/functions-sequence.html
Description:
This page:
https://www.postgresql.org/docs/current/functions-sequence.html
doesn't seem to mention that there's a way to get the "cross session"
current value of a sequence:
https://stackoverflow.com/a/12482716/32453
Cheers!
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: https://www.postgresql.org/docs/current/functions-sequence.html
2020-10-19 19:31 https://www.postgresql.org/docs/current/functions-sequence.html PG Doc comments form <noreply@postgresql.org>
@ 2020-10-19 20:52 ` David G. Johnston <david.g.johnston@gmail.com>
2020-10-20 14:21 ` Re: https://www.postgresql.org/docs/current/functions-sequence.html Roger Pack <rogerpack2005@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: David G. Johnston @ 2020-10-19 20:52 UTC (permalink / raw)
To: rogerpack2005@gmail.com, Pg Docs <pgsql-docs@lists.postgresql.org>
On Mon, Oct 19, 2020 at 1:13 PM PG Doc comments form <noreply@postgresql.org>
wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/13/functions-sequence.html
> Description:
>
> This page:
> https://www.postgresql.org/docs/current/functions-sequence.html
> doesn't seem to mention that there's a way to get the "cross session"
> current value of a sequence:
> https://stackoverflow.com/a/12482716/32453
>
>
That page says "sequences are single row tables" which means you can query
them, it also links to CREATE SEQUENCE where "SELECT * FROM sequence_name"
is described explicitly, plus there is the implied existence of catalog
entries. That seems sufficient given that such usage is not all that
useful and so less is more when it comes to pointing it out to users who
should just stick to the provided functions.
David J.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: https://www.postgresql.org/docs/current/functions-sequence.html
2020-10-19 19:31 https://www.postgresql.org/docs/current/functions-sequence.html PG Doc comments form <noreply@postgresql.org>
2020-10-19 20:52 ` Re: https://www.postgresql.org/docs/current/functions-sequence.html David G. Johnston <david.g.johnston@gmail.com>
@ 2020-10-20 14:21 ` Roger Pack <rogerpack2005@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Roger Pack @ 2020-10-20 14:21 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: Pg Docs <pgsql-docs@lists.postgresql.org>
Okey dokey
Thanks!
On Mon, Oct 19, 2020, 2:53 PM David G. Johnston <david.g.johnston@gmail.com>
wrote:
> On Mon, Oct 19, 2020 at 1:13 PM PG Doc comments form <
> noreply@postgresql.org> wrote:
>
>> The following documentation comment has been logged on the website:
>>
>> Page: https://www.postgresql.org/docs/13/functions-sequence.html
>> Description:
>>
>> This page:
>> https://www.postgresql.org/docs/current/functions-sequence.html
>> doesn't seem to mention that there's a way to get the "cross session"
>> current value of a sequence:
>> https://stackoverflow.com/a/12482716/32453
>>
>>
> That page says "sequences are single row tables" which means you can query
> them, it also links to CREATE SEQUENCE where "SELECT * FROM sequence_name"
> is described explicitly, plus there is the implied existence of catalog
> entries. That seems sufficient given that such usage is not all that
> useful and so less is more when it comes to pointing it out to users who
> should just stick to the provided functions.
>
> David J.
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2020-10-20 14:21 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-10-19 19:31 https://www.postgresql.org/docs/current/functions-sequence.html PG Doc comments form <noreply@postgresql.org>
2020-10-19 20:52 ` David G. Johnston <david.g.johnston@gmail.com>
2020-10-20 14:21 ` Roger Pack <rogerpack2005@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox