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

From Michael Artz
Subject Re: Storing an ordered list
Date
Msg-id e9c163070607261713j21d8e9a1n2e2ea25bd30de39c@mail.gmail.com
Whole thread Raw
In response to Re: Storing an ordered list  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: Storing an ordered list  (Bruno Wolff III <bruno@wolff.to>)
Re: Storing an ordered list  ("Aaron Bono" <postgresql@aranya.com>)
List pgsql-sql
On 7/26/06, Bruno Wolff III <bruno@wolff.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?


pgsql-sql by date:

Previous
From: "Michael Artz"
Date:
Subject: Re: Storing an ordered list
Next
From: Bruno Wolff III
Date:
Subject: Re: Storing an ordered list