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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
