Re: [ADMIN] How to read a sequence without incrementing it?

2003-08-30 Thread Pierre Couderc
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

[ADMIN] How to read a sequence without incrementing it?

2003-08-29 Thread Pierre Couderc
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