sequence question
Started by Williams, Travis L, NPONSabout 23 years ago2 messagesgeneral
Can you manually update the last_value in a sequence? I moved some data around and manually put in some of the sequence numbers.. I fixed the problem.. but was wondering for furture reference.
Travis
Re: sequence question
On Thu, 9 Jan 2003, Williams, Travis L, NPONS wrote:
Can you manually update the last_value in a sequence? I moved some
data around and manually put in some of the sequence numbers.. I fixed
the problem.. but was wondering for furture reference.
You can use setval() on the sequence to change the next value generated.