Re: Storing an ordered list

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Michael Artz <mlartz(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Storing an ordered list
Date: 2006-07-26 20:39:54
Message-ID: 20060726203954.GA23437@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Jul 25, 2006 at 22:58:47 -0400,
Michael Artz <mlartz(at)gmail(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Marc G. Fournier 2006-07-26 21:29:32 DBD::Pg ... how would I format this prepare?
Previous Message Andrew Hammond 2006-07-26 19:29:56 Re: Help with privilages please