Kevin, thanks a lot for your answer! As my servers are production systems and as I have an acceptable workaround for my needs, I will wait around with a postgresql upgrade =)
I just tried to help with discovering of a potential bug =)) Anyway I'm very glad to know, that in new version it's not an issue already =) Kind regards Alexey Isaiko Television department consultant All-Russian Research Institute of TV and Radio Broadcasting Russian Media Group TV-channels: RUTV, Hip Hop Hit -----Original Message----- From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov] Sent: Monday, August 08, 2011 8:52 PM To: listar; pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #6154: wrong result with nested left-joins "listar" <lis...@mail.ru> wrote: > PostgreSQL version: 8.4.5 > Description: wrong result with nested left-joins > And this is the problem - value2 can't be NULL because of COALESCE in > sub4 (at least I think that it can't be =)) This works correctly in release 9.0.4 and development HEAD. I don't still have any machines handy which are running 8.4, but you might want to try it on the latest bug-fix version of 8.4 (currently 8.4.8) to see if the fix was back-patched. http://www.postgresql.org/support/versioning -Kevin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
