Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 0A9969FB84B for ; Tue, 17 Jul 2007 13:44:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 73654-05 for ; Tue, 17 Jul 2007 13:44:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id D2A6E9FB77C for ; Tue, 17 Jul 2007 13:44:43 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1IAqAF-0000fT-7L for pgsql-sql@postgresql.org; Tue, 17 Jul 2007 12:44:43 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id C31D33FAF; Tue, 17 Jul 2007 12:44:37 -0400 (EDT) Date: Tue, 17 Jul 2007 12:44:37 -0400 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: data dependent sequences? Message-ID: <20070717164437.GJ21688@phlogiston.dyndns.org> References: <1184515497.5778.141.camel@localhost.localdomain> <20070717150046.GC21688@phlogiston.dyndns.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/103 X-Sequence-Number: 28838 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. A -- Andrew Sullivan | ajs@crankycanuck.ca The plural of anecdote is not data. --Roger Brinner