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
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