Re: Best approach for a "gap-less" sequence

Поиск
Список
Период
Сортировка
От AgentM
Тема Re: Best approach for a "gap-less" sequence
Дата
Msg-id 0773E0E5-AA1A-4B95-997D-DB68AC270D8B@themactionfaction.com
обсуждение исходный текст
Ответ на Re: Best approach for a "gap-less" sequence  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Best approach for a "gap-less" sequence  (Jorge Godoy <jgodoy@gmail.com>)
Список pgsql-general
Since the gapless numbers are purely for the benefit of the tax
people, you could build your db with regular sequences as primary
keys and then regularly (or just before tax-time) insert into a table
which maps the gapless sequence to the real primary key.

-M



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

Предыдущее
От: "macgillivary"
Дата:
Сообщение: Re: Migrating PostgreSQL database to MySQL/MS Access
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: prepared statement already exists