Re: data dependent sequences? - Mailing list pgsql-sql

From Stuart
Subject Re: data dependent sequences?
Date
Msg-id f7j1et$4s2$1@sea.gmane.org
Whole thread Raw
In response to data dependent sequences?  ("Stuart McGraw" <smcg2297@frii.com>)
Responses Re: data dependent sequences?  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-sql
"Andrew Sullivan" <ajs@crankycanuck.ca> wrote in message news:20070717164437.GJ21688@phlogiston.dyndns.org...
> 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.



pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: data dependent sequences?
Next
From: Andrew Sullivan
Date:
Subject: Re: data dependent sequences?