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

Поиск
Список
Период
Сортировка
От Jorge Godoy
Тема Re: Best approach for a "gap-less" sequence
Дата
Msg-id 87zme7uvcn.fsf@gmail.com
обсуждение исходный текст
Ответ на Re: Best approach for a "gap-less" sequence  (Harald Fuchs <hf0731x@protecting.net>)
Список pgsql-general
Harald Fuchs <hf0731x@protecting.net> writes:

> Why putting gapless numbers into the database at all?  Just calculate them at
> query time.

And how would you retrieve the record that corresponds to invoice number
#16355, for example?  Recalculating few records is fine, but millions of them
everytime you need to recover some of those is something that doesn't look
efficient to me...

--
Jorge Godoy      <jgodoy@gmail.com>

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

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: Re: Best approach for a "gap-less" sequence
Следующее
От: "Jaime Casanova"
Дата:
Сообщение: Re: problem with a dropped database