Re: ORDER BY does not work as expected with multiple joins

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