Re: COUNT() with ORDER BY

On 14 jan, 17:02, "Andrus" <kobrule(dot)(dot)(dot)(at)hot(dot)ee> 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.
>
> Query looks quite resonable to me and should be accepted by PostgreSQL 8.3
> Beta.
>
> Andrus.

Give a name to the count column and create a subquery:

select *
from (
select count(col) as count_col
from test
) subquery_tmp_name_as_you_wish
order by count_col;