On Wed, Apr 20, 2011 at 1:37 AM, Tom Lane t...@sss.pgh.pa.us 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
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
Thom Brown t...@linux.com 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