From: Tom Lane <tgl@sss.pgh.pa.us>
To: Adam Rosi-Kessel <adam@rosi-kessel.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: ORDER BY does not work as expected with multiple joins
Date: Fri, 13 Jan 2006 09:56:08 -0500
Message-ID: <25011.1137164168@sss.pgh.pa.us> (raw)
In-Reply-To: <43C7BA12.90103@rosi-kessel.org>
References: <43C7BA12.90103@rosi-kessel.org>
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
One comment is that your joining seems wrong: I'd have thought the
RIGHT JOIN should be LEFT JOIN for what you're trying to do. But that
shouldn't make any difference to whether the sort order is correct.
regards, tom lane
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: tgl@sss.pgh.pa.us, adam@rosi-kessel.org
Subject: Re: ORDER BY does not work as expected with multiple joins
In-Reply-To: <25011.1137164168@sss.pgh.pa.us>
* 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