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

Re: [HACKERS] Wishlist for next version: group by clause

From: David Hartwig <daveh(at)insightdist(dot)com>
To: De Clarke <de(at)ucolick(dot)org>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Wishlist for next version: group by clause
Date: 1998-06-16 20:27:35
Message-ID: 3586D537.57ABC1DF@insightdist.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Do you mean in a select statement?   Such as:

    SELECT func(date) as month, count(*) FROM foo GROUP BY month;

Or even:

    SELECT count(*) FROM foo GROUP BY func(date);

The first is supported.   The second would require some changes to the parser.

De Clarke wrote:

> I didn't realize PG could not do
>
>         group by [function on column]
>
> Ouch!
>




In response to

Responses

pgsql-hackers by date

Next:From: Brett McCormickDate: 1998-06-16 20:58:40
Subject: Re: [HACKERS] non-functional update notice unneccesarily
Previous:From: Bruce MomjianDate: 1998-06-16 19:09:41
Subject: Re: [HACKERS] Wishlist for next version: group by clause

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