Just FYI, SELECT last_value FROM my_sequence; is NOT transaction safe,
i.e. other transactions may increment the counter between the time you run
that query and the next that uses the value.
On Sat, 30 Aug 2003, Pierre Couderc wrote:
Thank you all.
SELECT last_value FROM my_sequence;
is
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
On Fri, 29 Aug 2003, 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)?
SELECT last_value FROM
to read a sequence without incrementing it?
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
select last_value from 'seq';
From: Pierre Couderc <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [ADMIN] How to read a sequence without incrementing it?
Date: Fri, 29 Aug 2003 18:27:09 +0200
I would like to read the current value of a sequence, or a value not
too far of the c