Try giving the "count" items names. I just ran the
following with good results:
select fy, yrmo, count(pt_id) as cases,
count(er_level) as er_cases from case_fy2003 group by
fy, yrmo order by cases desc;
Does this address your issue?
Andrew Gould
--- nolan@celery.tssi.com wrote:
> The following does NOT produce an error on the
> 'order by' clause,
> though perhaps it should?
>
> SELECT col, count(*) from table group by col
> order by count;
>
> If there is more than one count() function in the
> query, it does crete
> am error for the ambiguous reference.
>
> (FWIW, Oracle and MySQL both generate an error.)
> --
> Mike Nolan
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>
http://www.postgresql.org/docs/faqs/FAQ.html