At 11:46 AM +0530 2/24/2006, Ajay Dalvi wrote:
>HI all,
> In case of sequence in ingres, is there any command available to set
> the value of the sequence to some value.
>
>For e.g. Lets sequence name is "mysequence"
>Then in case of postgresql we can set the value of a sequence to say value 12,
> as follows:
>
> SELECT pg_catalog.setval('mysequence', 12, false);
>
>So can we have same behaviour in ingres?
>
>There is ALTER SEQUENCE Command available in ingres that has restart clause.
>But this command changes the actual definition of sequence.
I don't understand. You want to change the sequence without changing
the sequence? I'm not clear on what you are trying to achieve here.
Perhaps you could explain what real life problem you are trying
to solve, that ALTER SEQUENCE doesn't solve.
Karl
_______________________________________________
Users mailing list
[email protected]
http://ingres.ca.com/mailman/listinfo/users
