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.