Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #3588: coalesce not working in join - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3588: coalesce not working in join
Date
Msg-id 13471.1188432001@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3588: coalesce not working in join  ("Richard Harris" <richard_haris@adp.com>)
List pgsql-bugs
Tree view 
"Richard Harris" <richard_haris@adp.com> writes:
> Is PG 8.2.4 behavior correct?

Nope :-(  ... looks like some sorta bug in the rules for when outer
joins can be rearranged.  It's doing the t1a/t1b join first, and
then taking that as the right side of the join to t2, which means
that the t1b column goes to null if there's not a match to t2.pkt2.
Needs some study ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #3587: EXECUTE and trigger problem [VASCL:A163D284A86]
Next
From: "fuminori ido"
Date:
Subject: BUG #3589: /etc/init.d/postgresql reload doesn't reflect /etc/postgresql/postgresql.conf log_statement