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