On Fri, May 14, 2021 at 5:32 PM Michael Shapiro
wrote:
> I tried this. I created a sequence, and ran last_value, then nextval,
> repeatedly. last_value always returned 20 until nextval returned 21, then
> last_value returned 40 and kept returning 40 until nextval returned 41, etc.
>
Weird things
I tried this. I created a sequence, and ran last_value, then nextval,
repeatedly. last_value always returned 20 until nextval returned 21, then
last_value returned 40 and kept returning 40 until nextval returned 41, etc.
On Fri, May 14, 2021 at 9:39 AM Dave Page wrote:
>
>
> On Fri, May 14, 202
On Fri, May 14, 2021 at 3:33 PM Michael Shapiro
wrote:
> How does PgAdmin get the current value of a sequence when showing the
> sequence properties?
>
SELECT last_value FROM ;
(essentially. It gets a few other things as well)
--
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake
How does PgAdmin get the current value of a sequence when showing the
sequence properties?
