Re: [GENERAL] Possible outer join bug with coalesce in 8.2

2007-02-14 Thread Tom Lane
John McCawley <[EMAIL PROTECTED]> writes: > My development machine is PostgreSQL 8.1.5, and my production machine is > PostgreSQL 8.2. Until now I haven't run into any differences in > behavior. I have a query with a relatively wacky join, and while it was > working on my development machine,

Re: [GENERAL] Possible outer join bug with coalesce in 8.2

2007-02-13 Thread Tom Lane
John McCawley <[EMAIL PROTECTED]> writes: > What exactly is going on here? EXPLAIN might shed some light. However, if you think this is a bug then you need to provide a self-contained test case. regards, tom lane ---(end of broadcast)-

[GENERAL] Possible outer join bug with coalesce in 8.2

2007-02-13 Thread John McCawley
My development machine is PostgreSQL 8.1.5, and my production machine is PostgreSQL 8.2. Until now I haven't run into any differences in behavior. I have a query with a relatively wacky join, and while it was working on my development machine, it wouldn't work on the production machine. The