At 12:22 PM +0530 2/24/2006, Ajay Dalvi wrote: >... > The after execution of the alter sequence command , if we see the > definition of sequence, > by using > > help sequence mysequence \g > > it will show: > > create sequence mysequence as integer > start with 12 > > What I actually want is the behaviour same as if we execute following > command 12 times > > select next value for mysequence \g >
Hi Ajay, I guess I am stupid tonight. I am not seeing the practical difference between these. You want a sequence to act as if 12 values have been used up, but you don't want the sequence to start at 12? ??? What is the difference between these two, in the real world? Karl _______________________________________________ Users mailing list [email protected] http://ingres.ca.com/mailman/listinfo/users
