Ordering rows in a table

Hi,

the subject of this message may be a bit misleading.

I have the following scenario...I have a menu on a webpage that points to 
different pages, the table looks something like this:

id SERIAL, title varchar(64), url varchar(256)

Now I'd like to add an admin page where the order of the menu items can be 
changed. Specifically commands for moving an entry to the top or bottom of the 
list would be good. But I have no idea how to do this.

The ideas I've had som far...

adding an extra sort field (SERIAL), this would allow the order to be swapped 
between two rows by swapping the value of their sort fields....this is not 
exactly what I want tough.

I've also considered reading the entire table and calculating new "sort" values 
for each row but this seems very ineffective and not very "elegant".

So how would I do this in a "neat" way?

Thanks in advance,
David Härdeman

PS
Please CC any replies to me

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html