Postgres Pro
Downloads
Home   >   mailing lists

Re: GROUP BY Wildcard Syntax Thought - Mailing list pgsql-general

From Tom Lane
Subject Re: GROUP BY Wildcard Syntax Thought
Date
Msg-id 17241.1304541761@sss.pgh.pa.us
Whole thread Raw
In response to GROUP BY Wildcard Syntax Thought  ("David Johnston" <polobo@yahoo.com>)
List pgsql-general
Tree view 
"David Johnston" <polobo@yahoo.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

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: ZEOS or PGDAC - How to lock a resource?
Next
From: Scott Marlowe
Date:
Subject: Re: pervasiveness of surrogate (also called synthetic) keys