Re: incrementing updates and locks

Поиск
Список
Период
Сортировка
От Craig James
Тема Re: incrementing updates and locks
Дата
Msg-id 4C92A2F8.2050209@emolecules.com
обсуждение исходный текст
Ответ на incrementing updates and locks  (Aras Angelo <araskoktas@gmail.com>)
Ответы Re: incrementing updates and locks
Список pgsql-admin
On 9/16/10 3:54 PM, Aras Angelo wrote:
> Hello All
>
> I have a column in my table which is incrementally updated.

Try to give us more details...

Does the column need have contiguous values or are "gaps" ok?  That is, does it have to be 1,2,3,4,...,N-1,N or is it
okto have something like 1,3,4,7,...,M (where M>N) for N rows? 

Is the value updated every time the row is changed, or is it set once only?

If gaps are OK, then a sequence is a simple answer.

Craig

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

Предыдущее
От: "Daniel J. Summers"
Дата:
Сообщение: Re: incrementing updates and locks
Следующее
От: Aras Angelo
Дата:
Сообщение: Re: incrementing updates and locks