list ranking - Mailing list pgsql-admin

From Jodi Kanter
Subject list ranking
Date
Msg-id 3EEA1F57.1070002@virginia.edu
Whole thread Raw
Responses Re: list ranking  (Joe Conway <mail@joeconway.com>)
List pgsql-admin
We have a set of records in a table that needs to be ranked. We thought of adding a ranking field, but the problem is that the ranking could change often and there could be additions and deletions from the list. Updating this ranking field is quickly going to get messy.

Is anyone familiar with link surgery? Can we do this with a doubly linked list? Is there a standard database solution for doubly linked lists? or another way to solve this that I don't see?
Any suggestions on structure would be greatly appreciated.

Thanks
Jodi
--

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu


 

 

 

pgsql-admin by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Postgres Size-limit
Next
From: Michael Sheldon
Date:
Subject: LAST REQUEST: Remove