Re: [GENERAL] How to get back the current count of a auto incrementing number.

2005-01-28 Thread PFC
This question pops about once a day... can't the list server grep for "auto increment" and send a link to the docs itself ;) 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

Re: [GENERAL] How to get back the current count of a auto incrementing number.

2005-01-28 Thread Sean Davis
On Jan 28, 2005, at 6:36 AM, sid tow wrote: 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

Re: [GENERAL] How to get back the current count of a auto incrementing number.

2005-01-28 Thread Shridhar Daithankar
On Friday 28 Jan 2005 5:06 pm, sid tow wrote: > 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 cu

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

2005-01-28 Thread sid tow
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. _