Re: COUNT() with ORDER BY

On Mon, Jan 14, 2008 at 09:02:46PM +0200, Andrus wrote:
> 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.

Sorry? The query is entirely non-sensical. The output will be a single
row telling you the number of non-null elements in the col column. How
can it be ordered?

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy