On Wed, Apr 20, 2011 at 1:37 AM, Tom Lane wrote:
>> 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 CO
Thom Brown writes:
> 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
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
