Re: [BUGS] count() bug in trivial self join

2001-02-27 Thread Tom Lane
John Foderaro <[EMAIL PROTECTED]> writes: > postgresql version: 6.5.3 (my guess based on rpm name). Fixed long since ... update ... regards, tom lane

[BUGS] count() bug in trivial self join

2001-02-27 Thread John Foderaro
from: john foderaro, [EMAIL PROTECTED] platform: x86 running Redhat 6.2 Linux from rpm postgresql-server-6.5.3-6 postgresql version: 6.5.3 (my guess based on rpm name). problem: count() return the wrong result given a very simple join: sample: we create a table of 3 elements an