Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-15 Thread Craig Ringer
[Note: I'm *not* an expert in the SQL standard, but I might be able to help clarify a misunderstanding or two in the discussion so far]. Tony Marston wrote: Support for functional dependencies is not a feature that can be turned off in any database engine. Dependencies, whether they are functio

Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-15 Thread David Fetter
On Tue, Oct 14, 2008 at 08:28:42PM -0400, Bruce Momjian wrote: > Tony Marston wrote: > > I think your definition of "Feature T301 Functional Dependencies" > > is extremely questionable. [et cetæra, ad nauseam] > > The issue is that Postgres is _more_ standards-compliant than MySQL, > but Postgres

Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-15 Thread Andrew Sullivan
On Wed, Oct 15, 2008 at 01:47:40PM +0100, Tony Marston wrote: > Support for functional dependencies is not a feature that can be > turned off in any database engine. Repeating the same premise over and over again does not constitute an argument. In this case, you appear to be begging the questio

Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-15 Thread Tony Marston
tp://www.tonymarston.net http://www.radicore.org > -Original Message- > From: Peter Eisentraut [mailto:[EMAIL PROTECTED] > Sent: 15 October 2008 11:53 > To: Tony Marston > Cc: 'Gregory Stark'; pgsql-bugs@postgresql.org > Subject: Re: [BUGS] BUG #4465: GROUP BY is n

Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-15 Thread Peter Eisentraut
Tony Marston wrote: You are still missing the point - "functional dependencies" is not a separate module that can be turned on or off with code, It is in the SQL standard. they are inherent in the database design. According to relational theory any non-key field on a table is functionally dep

Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-15 Thread Tony Marston
You are still missing the point - "functional dependencies" is not a separate module that can be turned on or off with code, they are inherent in the database design. According to relational theory any non-key field on a table is functionally dependent of the key of that table, so if you support bo

Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-14 Thread Gregory Stark
"Tony Marston" <[EMAIL PROTECTED]> writes: > I think your definition of "Feature T301 Functional Dependencies" is > extremely questionable. ... If you support both key and non-key columns on a > table then you support functional dependencies whether you like it or not. An ISO/IEC 9075 conformant

Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-14 Thread Peter Eisentraut
Tony Marston wrote: I think your definition of "Feature T301 Functional Dependencies" is extremely questionable. A functional dependency in relational theory automatically exists where a non-key column on a table is functionally dependent on the key of that table. It is not something that can be

Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-14 Thread Bruce Momjian
Tony Marston wrote: > I think your definition of "Feature T301 Functional Dependencies" is > extremely questionable. A functional dependency in relational theory > automatically exists where a non-key column on a table is functionally > dependent on the key of that table. It is not something that c

Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-14 Thread Tony Marston
TED] > Sent: 14 October 2008 20:17 > To: Tony Marston > Subject: Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard > > > Tony Marston wrote: > > I am using document WG3:HBA-003 H2-2003-305 dated August 2003. > > > > Section 7.9 - 7 of the SQL-1992 stand

Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-10 Thread Peter Eisentraut
Tony Marston wrote: The following bug has been logged online: Bug reference: 4465 Logged by: Tony Marston Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.4 Operating system: Windows XP Description:GROUP BY is not to SQL standard Details: The Postgresql im

[BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-10 Thread Tony Marston
The following bug has been logged online: Bug reference: 4465 Logged by: Tony Marston Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.4 Operating system: Windows XP Description:GROUP BY is not to SQL standard Details: The Postgresql implementation of GROUP