Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B01BE9FB280 for ; Tue, 10 Apr 2007 14:01:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 56190-07-2 for ; Tue, 10 Apr 2007 14:01:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 9F60B9FB254 for ; Tue, 10 Apr 2007 14:01:03 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 3EDD030B2B; Tue, 10 Apr 2007 19:01:02 +0200 (MET DST) From: Peter Wilson X-Newsgroups: pgsql.general Subject: Re: programmatic way to fetch latest release for a given major.minor version Date: Tue, 10 Apr 2007 18:00:59 +0100 Organization: Hub.Org Networking Services Lines: 31 Message-ID: References: <1176155240.221125.319880@y80g2000hsf.googlegroups.com> <467669b30704091526v79ae044boe7217cc0777dce1f@mail.gmail.com> <5a0a9d6f0704091534i4e4af90co2dad0e9e0b60efee@mail.gmail.com> <461B3E6A.8080007@postgresql.org> <20070410081558.GB24976@svr2.hagander.net> <461B5064.8010004@postgresql.org> <20070410101852.GC24976@svr2.hagander.net> <461B6F10.3040800@postgresql.org> <20070410111509.GF24976@svr2.hagander.net> <87tzvo6urb.fsf@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) In-Reply-To: <87tzvo6urb.fsf@gmail.com> X-Enigmail-Version: 0.94.0.0 To: pgsql-general@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/451 X-Sequence-Number: 112354 Jorge Godoy wrote: > Listmail writes: > >>>> Yeah yeah, but terminology aside, having 2 or three digits in each >>>> attribute is just wrong! >>> Terminology aside, why? The unit is "8.1" not "8" and "1". It makes no >>> sense to say you're on version 8, in the given context, so why should the >>> XML data pretend there is? >>> >>> //Magnus >> Just pretend that : >> >> - version = a tuple of integers (a, b, c, ...) >> - major = (a, b) >> - minor = (c, ...) >> >> Besides, that is sortable (unlike strings where 15 < 2) : > > But then, floats are as sortable as integers and 8.3 < 15.1... > > 8.7, 8.9, 8.10 - oops. 8.10 < 8.9 The 'period' is effectively a field separator, with the unfortunate side-effect that it looks like a number. Unless of course, the version after 8.9 *will* be 9.0, in which case it is a number and you're right. Pete