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 my_sequence;
where my_sequence is the sequence name.
try:
\d my_sequence; (same substitution as before)
for more info.
--
Sam Barnett-Cormack
Software Developer | Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University