Re: [pgadmin-hackers] Insufficient description in collation mismatch error

2011-04-19 Thread Thom Brown
On 19 April 2011 23:57, Thom Brown 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" mu

[pgadmin-hackers] Insufficient description in collation mismatch error

2011-04-19 Thread Thom Brown
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 aggre