Adam Rosi-Kessel <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
