"Andrew Sullivan" <ajs(at)crankycanuck(dot)ca> wrote in message news:20070717164437(dot)GJ21688(at)phlogiston(dot)dyndns(dot)org(dot)(dot)(dot)
> On Tue, Jul 17, 2007 at 09:40:21AM -0600, Stuart wrote:
> > is not really structually important -- it is a value that
> > exists soley for the UI.
>
> Hmm. Maybe you should use generate_series() for the UI instead? It
> would always give you the order you like, you could use the universal
> sequence or whatever for your ORDER BY clause, and not store data
> that you actually don't care about.
Except that the value does matter outside of the database and thus
needs to be remembered. It is not used for ordering at all.