Re: GROUP BY Wildcard Syntax Thought

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David Johnston" <polobo(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: GROUP BY Wildcard Syntax Thought
Date: 2011-05-04 20:42:41
Message-ID: 17241.1304541761@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"David Johnston" <polobo(at)yahoo(dot)com> writes:
> When specifying columns in a GROUP BY clause would it be possible to use a
> wildcard to specify all columns coming from a given relation?

I think the need for this will be largely superseded by the SQL-standard
behavior that grouping by a primary key is sufficient (which we've
finally implemented as of 9.1).

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2011-05-04 20:48:06 Re: pervasiveness of surrogate (also called synthetic) keys
Previous Message Merlin Moncure 2011-05-04 20:31:14 Re: ZEOS or PGDAC - How to lock a resource?