[BUGS] BUG #7486: Error Group by

[anders...@gmail.com]

The following bug has been logged on the website:

Bug reference: 7486
Logged by: Anderson Abreu
Email address: anders...@gmail.com
PostgreSQL version: 8.4.12
Operating system: Linux
Description:

Dear,

I'm test the script, for example: select attA, attB from table1 group by
attA.

In postgre 8.4.X show error column attB must appear in the GROUP BY clause
or be used in an aggregate function.

But, in postgre 9.1.X the query running sucesfully.

Why?

Thank's


-
Sent via pgsql-bugs mailing list (pgsql...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

[Daniel Farina]

On Fri, Aug 10, 2012 at 10:33 AM, <anders...@gmail.com> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7486
> Logged by: Anderson Abreu
> Email address: anders...@gmail.com
> PostgreSQL version: 8.4.12
> Operating system: Linux
> Description:
>
> Dear,
>
> I'm test the script, for example: select attA, attB from table1 group by
> attA.
>
> In postgre 8.4.X show error column attB must appear in the GROUP BY clause
> or be used in an aggregate function.
>
> But, in postgre 9.1.X the query running sucesfully.
>
> Why?

attA is probably a primary key, is that the case?

http://www.postgresql.org/docs/9.1/static/release-9-1.html#AEN107670

"Allow non-GROUP BY columns in the query target list when the primary
key is specified in the GROUP BY clause (Peter Eisentraut)

The SQL standard allows this behavior, and because of the primary key,
the result is unambiguous."

--
fdr