Re: Improving GROUP BY?

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

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.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Seberg 2005-09-30 13:31:07 Re: Improving GROUP BY?
Previous Message James Cradock 2005-09-30 12:44:19 Re: to drop a 30GB database. is it slow?