Re: Storing an ordered list

From: "Michael Artz" <mlartz(at)gmail(dot)com>
To: "Bruno Wolff III" <bruno(at)wolff(dot)to>, "Michael Artz" <mlartz(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Storing an ordered list
Date: 2006-07-27 00:13:03
Message-ID: e9c163070607261713j21d8e9a1n2e2ea25bd30de39c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 7/26/06, Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
> If you use numeric instead of int, then it is easy to insert new values.

Hmm, hadn't thought about that. How would you normally implement it?
I'm thinking that, if I wanted to insert between A and B, I could take
(A.order + B.order)/2, which would be pretty simple. Is there a
better way?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2006-07-27 13:18:23 Re: Storing an ordered list
Previous Message Michael Artz 2006-07-27 00:09:27 Re: Storing an ordered list