[SQL] Maintaining an order for a group of records

2003-11-28 Thread Bruno De Fraine
Hello group, I'm looking for a neat way to accomplish the following with PostgreSQL. In a table, I have a group of records for which I want to store an order. The order has nothing to do with the data of the records; on the contrary, the order of the records might change without the (other) dat

[SQL] Maintaining an order for a group of records

2003-11-24 Thread Bruno De Fraine
Hello group, I'm looking for a neat way to accomplish the following with PostgreSQL. In a table, I have a group of records for which I want to store an order. The order has nothing to do with the data of the records; on the contrary, the order of the records might change without the (other) dat