Re: Storing an ordered list - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: Storing an ordered list
Date
Msg-id 20060726203954.GA23437@wolff.to
Whole thread Raw
In response to Storing an ordered list  ("Michael Artz" <mlartz@gmail.com>)
Responses Re: Storing an ordered list
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 by date:

Previous
From: "Andrew Hammond"
Date:
Subject: Re: Help with privilages please
Next
From: "Marc G. Fournier"
Date:
Subject: DBD::Pg ... how would I format this prepare?