SELECT last_value FROM my_sequence;
is the good solution.
(Currval() does not work as there is no nextval() before in the session)
Pierre Couderc
Pierre Couderc wrote:
I would like to read the current value of a sequence, or a value not too far of the current value (for example, the value it was a few seconds or minutes ago). Is it possible (without any nexrval that should increment it)?
Thank you all
Pierre Couderc
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
