Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT, GROUP BY, and aggregates - Mailing list pgsql-general

From Bill Moran
Subject Re: SELECT, GROUP BY, and aggregates
Date
Msg-id 20150213132630.00ca5b669114bc903736d5f7@potentialtech.com
Whole thread Raw
In response to Re: SELECT, GROUP BY, and aggregates  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SELECT, GROUP BY, and aggregates  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
Tree view 
> Ryan Delaney <ryan.delaney@gmail.com> writes:
> > Why couldn't an RDBMS such as postgres interpret a SELECT that omits the GROUP
> > BY as implicitly grouping by all the columns that aren't part of an aggregate?

I'm Mr. Curious today ...

Why would you think that such a thing is necessary or desirable? Simply add the
columns to the GROUP BY clause and make the request unambiguous.

--
Bill Moran

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Contrib build fault for pgdg postgres 9.2 at debian 6 (squeeze)
Next
From: Jeff Janes
Date:
Subject: Re: SELECT, GROUP BY, and aggregates