Обсуждение: Re: COUNT() with ORDER BY

On 14 jan, 17:02, "Andrus" <kobrule...@hot.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;