Skip site navigation (1) Skip section navigation (2)

BUG #4465: GROUP BY is not to SQL standard

From: "Tony Marston" <tony(at)marston-home(dot)demon(dot)co(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4465: GROUP BY is not to SQL standard
Date: 2008-10-10 09:47:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4465
Logged by:          Tony Marston
Email address:      tony(at)marston-home(dot)demon(dot)co(dot)uk
PostgreSQL version: 8.3.4
Operating system:   Windows XP
Description:        GROUP BY is not to SQL standard

The Postgresql implementation of GROUP BY does not conform to either the
1999 or 2003 SQL standard. The documentation states that every field in the
SELECT list which is not aggregated must be specified in the GROUP BY
clause. While this was true in the 1992 standard, in 1999 this was changed
to "any non-aggregated column appearing in the SELECT list is functionally
dependent upon the GROUP BY clause". In the example both and p.price
are functionally dependent on product_id, therefore there is no need for
them to be included in the GROUP BY clause.

In this respect Postgresql is wrong and MySQL is right.


pgsql-bugs by date

Next:From: Peter EisentrautDate: 2008-10-10 16:56:30
Subject: Re: BUG #4465: GROUP BY is not to SQL standard
Previous:From: zhengzhong_zhouDate: 2008-10-10 07:59:21
Subject: BUG #4463: unique constraint error

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group