Thank you all.
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
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