COUNT() with ORDER BY - Mailing list pgsql-general

create temp table test (col char);
select count(col) from test order by col;

causes

ERROR:  column "test.col" must appear in the GROUP BY clause or be used in
an aggregate function
SQL state: 42803


How to fix this ?
This statement is generated by DbLinq driver and it is difficult to re-qrite
the driver.

Query looks quite resonable to me and should be accepted by PostgreSQL 8.3
Beta.


Andrus.