Sequence - Use calculated start value?

Поиск
Список
Период
Сортировка
От Aragorn
Тема Sequence - Use calculated start value?
Дата
Msg-id s8Vv9.634253$Ag2.24396370@news2.calgary.shaw.ca
обсуждение исходный текст
Ответы Re: Sequence - Use calculated start value?  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-general
I need to use a calculated start value for some sequences. eg:

CREATE SEQUENCE tblco_cntcoid_key start (SELECT (MAX(cntcoid) + 100)
FROM tblco) increment 1 maxvalue 2147483647 minvalue 1  cache 1;

when I try this I get:
   ERROR: parser: parse error at or near (

I am migrating an MS Access DB to postgresql and need to retain the
current value of the id columns (er cntcoid), but when I insert new
values I want the cntcoid to start at a number greater than the last one
in the table. When I use a normal sequence or serial type for the id,
any new records are inserted starting at id 1.

Anyone know how to do this?

Thanks

--
Ron
Syscor R&D



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

Предыдущее
От: Johannes Lochmann
Дата:
Сообщение: Re: [SQL] Database Design tool
Следующее
От: terry@greatgulfhomes.com
Дата:
Сообщение: how to force drop a table