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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings