Re: Improving GROUP BY?

From: Oliver Siegmar <oliver(at)siegmar(dot)net>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Improving GROUP BY?
Date: 2005-09-30 13:38:20
Message-ID: 200509301538.20376.oliver@siegmar.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday 30 September 2005 15:23, Peter Eisentraut wrote:
> Am Freitag, 30. September 2005 09:03 schrieb Oliver Siegmar:
> > - Would it be possible to add a feature to PostgreSQL to allow grouping
> > by unique identifiers only?
> > - Is this requirement (all fields in GROUP BY) based on the SQL standard?
>
> What you describe is called "functional dependencies" in the SQL standard.
> (The query processor would recognize that the non-primary key columns
> "functionally depend" on the primary key and therefore do not have to be
> grouped separately.) This is definitely a valid feature but PostgreSQL
> does not implement it yet.

Could you add it to the TODO list? ;-)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-09-30 14:00:53 Re: Improving GROUP BY?
Previous Message John Seberg 2005-09-30 13:31:07 Re: Improving GROUP BY?