X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 3C87D9DCBB5 for ; Fri, 13 Jan 2006 12:20:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36583-02 for ; Fri, 13 Jan 2006 12:20:16 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.199]) by postgresql.org (Postfix) with ESMTP id F1ED79DCB47 for ; Fri, 13 Jan 2006 12:20:15 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i28so751750wra for ; Fri, 13 Jan 2006 08:20:12 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Vo6ITw7dwUtYkK2J8p6sQ5DnSa4t8ogPeRvd4oK34YfLtaGk3tnstExmVcDloLB5RrEYMKScUp8ZAR4Sz0KGyRlLa238uJUo9feJbOjZAwiTpwkQklfYvZZ59alHsZ5qPQID/nJC0ROhmw+NdY03xccS3AP+5VpKQmto37Q5wxc= Received: by 10.54.83.7 with SMTP id g7mr4208756wrb; Fri, 13 Jan 2006 08:20:11 -0800 (PST) Received: by 10.54.93.8 with HTTP; Fri, 13 Jan 2006 08:20:11 -0800 (PST) Message-ID: Date: Fri, 13 Jan 2006 11:20:11 -0500 From: Jaime Casanova To: Adam Rosi-Kessel Subject: Re: ORDER BY does not work as expected with multiple joins Cc: Tom Lane , pgsql-sql@postgresql.org In-Reply-To: <43C7C3E2.1030205@rosi-kessel.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <43C7BA12.90103@rosi-kessel.org> <25011.1137164168@sss.pgh.pa.us> <43C7C3E2.1030205@rosi-kessel.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.088 required=5 tests=[AWL=0.088] X-Spam-Score: 0.088 X-Spam-Level: X-Archive-Number: 200601/67 X-Sequence-Number: 23856 On 1/13/06, Adam Rosi-Kessel wrote: > Tom Lane wrote: > > Adam Rosi-Kessel writes: > >> I have a multijoin SELECT statement where the ORDER BY clause doesn't > >> seem to be working. > > You haven't mentioned your Postgres version, nor provided anywhere near > > enough information to let other people reproduce the problem. You migh= t > > find it helpful to read this: > > http://www.postgresql.org/docs/8.1/static/bug-reporting.html > > Thanks. I didn't think this was a bug--I thought I had an error in my SEL= ECT > statement somehow. I certainly would have included more information with = a > bug report. (For the record, it is PostgreSQL 7.4 from Debian Sarge). > Tom's comment about this was, AFAICT, because you didn't show in the first post OS version nor postgres version, you didn't show your own results either (and that is a good start to try to see the reason of your problem... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)