Re: sequence, set value of
От | zilch@home.se |
---|---|
Тема | Re: sequence, set value of |
Дата | |
Msg-id | 20010617205156.A16388@loony обсуждение исходный текст |
Ответ на | Re: sequence, set value of ("Tim Barnard" <tbarnard@povn.com>) |
Ответы |
Re: sequence, set value of
|
Список | pgsql-general |
So, if I want the next insert to make the ID automatically 1, i can't use SERIAL since that gives me a sequence of minvalue 1? Wich results in a id = 2 in the next insert. Right? Daniel Akerud > select setval('sequencename',newvalue) > > See docs at: www.portgresql.org/idocs/index.php?sql-createsequence.html > > Tim > > ----- Original Message ----- > From: <zilch@home.se> > To: <pgsql-general@postgresql.org> > Sent: Sunday, June 17, 2001 10:36 AM > Subject: [GENERAL] sequence, set value of > > > > > > Forgott how to set the value of a sequence, > > please tell. > > > > Daniel Akerud > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > > > --- Daniel Åkerud, zilch@home.se
В списке pgsql-general по дате отправления: