Re: [HACKERS] asterisk (non)expansion in GROUP BY clause

2011-05-20 Thread Tom Lane
Peter Eisentraut writes: > Apparently, you can write this (an attempt at a convenient workaround > for lack of functional dependency tracking pre-9.1): > SELECT pg_class.* FROM pg_class GROUP BY pg_class.*; > It won't work: > ERROR: 42803: column "pg_class.relname" must appear in the GROUP BY

[HACKERS] asterisk (non)expansion in GROUP BY clause

2011-05-19 Thread Peter Eisentraut
Apparently, you can write this (an attempt at a convenient workaround for lack of functional dependency tracking pre-9.1): SELECT pg_class.* FROM pg_class GROUP BY pg_class.*; It won't work: ERROR: 42803: column "pg_class.relname" must appear in the GROUP BY clause or be used in an aggregate f