Re: [HACKERS] [SQL] What's wrong with this group by clause?

2003-03-13 Thread Manfred Koizar
[forwarding to -hackers] On Tue, 4 Nov 2003 18:28:12 -0300, Franco Bruno Borghesi [EMAIL PROTECTED] wrote: Below you can find a simplified example of a real case. I don't understand why I'm getting the john record twice. ISTM you have found a Postgres 7.3 bug. I get one john with PostgreSQL

Re: [HACKERS] [SQL] What's wrong with this group by clause?

2003-03-13 Thread Christoph Haller
On Tue, 4 Nov 2003 18:28:12 -0300, Franco Bruno Borghesi [EMAIL PROTECTED] wrote: Below you can find a simplified example of a real case. I don't understand why I'm getting the john record twice. ISTM you have found a Postgres 7.3 bug. I get one john with PostgreSQL 7.1.3 on

Re: [HACKERS] [SQL] What's wrong with this group by clause?

2003-03-13 Thread Tom Lane
Manfred Koizar [EMAIL PROTECTED] writes: ISTM you have found a Postgres 7.3 bug. Yeah. Actually, the planner bug has been there a long time, but it was only latent until the parser stopped suppressing duplicate GROUP BY items: 2002-08-18 14:46 tgl * src/backend/parser/parse_clause.c: