I posted this message once through the Google Groups interface to pgsql.sql,
but I've received no replies and the message doesn't appear at all in the
MHonArc archives at postgresql.org, so I'm not sure it actually was
distributed to this list. Apologies if this is a duplicate:
I have a multijoin
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 helpfu
Tom Lane wrote:
> 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. Y
On Jan 13, 2006, at 23:32 , Adam Rosi-Kessel wrote:
I have a multijoin SELECT statement where the ORDER BY clause doesn't
seem to be working. I can't figure out how pgsql is sorting the
results, but it is definitely different from the same list without the
multiple joins.
What I am trying
Thanks for your helpful response.
Michael Glaesemann wrote:
> I don't seem to have a problem with the ordering given your data. I'm
> not sure why you're doing right and left joins, though. You might want
> to use left joins if you have NULL id1 or id2, but otherwise just plain
> JOIN should work
On Jan 14, 2006, at 0:22 , Adam Rosi-Kessel wrote:
id1 will always have a value but id2 can be NULL. So should I do a
left JOIN
on id2 but a plain JOIN on id1? Is there a disadvantage to using a
left JOIN
where it is not necessary?
In that case, yes, I'd JOIN on id1 and LEFT JOIN on id2.
Adam Rosi-Kessel <[EMAIL PROTECTED]> writes:
> But I am curious why you think a LEFT JOIN should be used rather than RIGHT
> JOIN? I think I believe I am getting the desired set of records. When I
> substitute LEFT JOIN for RIGHT JOIN I actually get the same result. Can you
> help me understand und
On Jan 14, 2006, at 0:45 , Michael Glaesemann wrote:
On Jan 14, 2006, at 0:22 , Adam Rosi-Kessel wrote:
id1 will always have a value but id2 can be NULL. So should I do a
left JOIN
on id2 but a plain JOIN on id1? Is there a disadvantage to using a
left JOIN
where it is not necessary?
I
On 1/13/06, Adam Rosi-Kessel <[EMAIL PROTECTED]> wrote:
> Tom Lane wrote:
> > 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
