From: Jaime Casanova <systemguards@gmail.com>
To: Adam Rosi-Kessel <adam@rosi-kessel.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: ORDER BY does not work as expected with multiple joins
Date: Fri, 13 Jan 2006 11:20:11 -0500
Message-ID: <c2d9e70e0601130820v22fc527bnefaf16b5dbd6d09a@mail.gmail.com> (raw)
In-Reply-To: <43C7C3E2.1030205@rosi-kessel.org>
References: <43C7BA12.90103@rosi-kessel.org>
<25011.1137164168@sss.pgh.pa.us>
<43C7C3E2.1030205@rosi-kessel.org>
On 1/13/06, Adam Rosi-Kessel <adam@rosi-kessel.org> wrote:
> Tom Lane wrote:
> > Adam Rosi-Kessel <adam@rosi-kessel.org> 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 might
> > 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 SELECT
> 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 ;)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: systemguards@gmail.com, adam@rosi-kessel.org, tgl@sss.pgh.pa.us
Subject: Re: ORDER BY does not work as expected with multiple joins
In-Reply-To: <c2d9e70e0601130820v22fc527bnefaf16b5dbd6d09a@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox