[Users] Is there any command in ingres to set the value of Sequence

[Karl & Betty Schendel]

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