Re: Storing an ordered list

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Storing an ordered list
Дата
Msg-id 20060726203954.GA23437@wolff.to
обсуждение исходный текст
Ответ на Storing an ordered list  ("Michael Artz" <mlartz@gmail.com>)
Ответы Re: Storing an ordered list
Список pgsql-sql
On Tue, Jul 25, 2006 at 22:58:47 -0400, Michael Artz <mlartz@gmail.com> wrote:
> 
> I figure that one choice is to explicitly code the order as an integer
> column in the predicate table which has the advantage of being very
> easy and fast to query/order but *very* slow to reorder as all of the
> predicates need to be updated.  This would seem to be a postgres/MVCC
> weak spot as well.  Example:

If you use numeric instead of int, then it is easy to insert new values.


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

Предыдущее
От: "Andrew Hammond"
Дата:
Сообщение: Re: Help with privilages please
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: DBD::Pg ... how would I format this prepare?