Re: SERIAL type fields

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: SERIAL type fields
Дата
Msg-id 20030424195304.GA23845@wolff.to
обсуждение исходный текст
Ответ на Re: SERIAL type fields  (Andrew Ayers <aayers@eldocomp.com>)
Список pgsql-general
On Thu, Apr 24, 2003 at 12:43:24 -0700,
  Andrew Ayers <aayers@eldocomp.com> wrote:
>
> What I came across was that I wanted to reset the sequence number so
> that when the new records were added, they would start at number "1" and
> increase from there.

If you look at the documentation for setval, you will see that there is
an optional third argument that you can use to keep the value from
being incremented on the next nextval call.


В списке pgsql-general по дате отправления:

Предыдущее
От: "Vilson farias"
Дата:
Сообщение: pl-pgsql question
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: SERIAL type fields