How to get back the current count of a auto incrementing number.

[sid tow <siddy_tow@xxxxxxxxx>]

hi

     How to get the current value of a auto
incrementing number generated using CREATE SEQUENCE
seqname START 1

Is there any way and if yes what is it. Can we run a
select query and may be a inbuilt function which will
return the current value of that number?

Regards.


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)