On 19 April 2011 23:57, Thom Brown <[email protected]> wrote: > Hi, > > I tried applying a collation to a GROUP BY clause without applying the > collation to the corresponding column in the SELECT clause. > > postgres=# SELECT things, count(*) FROM stuff GROUP BY things COLLATE "C"; > ERROR: column "stuff.things" must appear in the GROUP BY clause or be > used in an aggregate function > LINE 1: SELECT things, count(*) FROM stuff GROUP BY things COLLATE "... > > Firstly, does it even make sense for a GROUP BY clause to accept COLLATE? > > Even if it does, this error message doesn't explain the problem, being > that the column with the necessary collation doesn't appear in the > SELECT.
Erk, please ignore. Wrong list. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
