<html><div style='background-color:'><DIV>
<P>select last_value from 'seq';<BR><BR></P></DIV>
<DIV></DIV>>From: Pierre Couderc <PIERRE(at)COUDERC(dot)CC>
<DIV></DIV>>To: pgsql-admin(at)postgresql(dot)org
<DIV></DIV>>Subject: [ADMIN] How to read a sequence without incrementing it?
<DIV></DIV>>Date: Fri, 29 Aug 2003 18:27:09 +0200
<DIV></DIV>>
<DIV></DIV>>I would like to read the current value of a sequence, or a value not
<DIV></DIV>>too far of the current value (for example, the value it was a few
<DIV></DIV>>seconds or minutes ago). Is it possible (without any nexrval that
<DIV></DIV>>should increment it)?
<DIV></DIV>>
<DIV></DIV>>Thank you all
<DIV></DIV>>
<DIV></DIV>>Pierre Couderc
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>---------------------------(end of
<DIV></DIV>>broadcast)---------------------------
<DIV></DIV>>TIP 4: Don't 'kill -9' the postmaster
<DIV></DIV></div><br clear=all><hr> <a href="http://g.msn.com/8HMJENUS/2749??PS="><b>Get MSN 8</b> and enjoy automatic e-mail virus protection. </a> </html>