Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id CB7F19FB71E
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 17 Jul 2007 15:23:49 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 13155-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 17 Jul 2007 15:23:41 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from ciao.gmane.org (main.gmane.org [80.91.229.2])
	by postgresql.org (Postfix) with ESMTP id 8FDC99FB667
	for <pgsql-sql@postgresql.org>; Tue, 17 Jul 2007 15:23:42 -0300 (ADT)
Received: from list by ciao.gmane.org with local (Exim 4.43)
	id 1IArhv-0002j1-Lm
	for pgsql-sql@postgresql.org; Tue, 17 Jul 2007 20:23:35 +0200
Received: from smcgraw.ppp.frii.com ([216.17.133.158])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Tue, 17 Jul 2007 20:23:35 +0200
Received: from smcg2297 by smcgraw.ppp.frii.com with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Tue, 17 Jul 2007 20:23:35 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-sql@postgresql.org
From: "Stuart" <smcg2297@frii.com>
Subject: Re: data dependent sequences?
Date: Tue, 17 Jul 2007 12:23:21 -0600
Lines: 13
Message-ID: <f7j1et$4s2$1@sea.gmane.org>
References: <AKEFJAHAPDBEDKIICNJKMEJPCDAA.smcg2297@frii.com>
	<1184515497.5778.141.camel@localhost.localdomain>
	<f7iggu$1nb$1@sea.gmane.org>
	<20070717150046.GC21688@phlogiston.dyndns.org>
	<f7int7$ue7$1@sea.gmane.org>
	<20070717164437.GJ21688@phlogiston.dyndns.org>
Mime-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@sea.gmane.org
X-Gmane-NNTP-Posting-Host: smcgraw.ppp.frii.com
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200707/104
X-Sequence-Number: 28839


"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.