Possible parsing problem?

From: nolan(at)celery(dot)tssi(dot)com
To: pgsql-general(at)postgresql(dot)org (pgsql general list)
Subject: Possible parsing problem?
Date: 2003-06-30 15:25:32
Message-ID: 20030630152533.17945.qmail@celery.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gianni Mariani 2003-06-30 16:09:20 Binary data
Previous Message Csaba Nagy 2003-06-30 14:41:04 Re: Making pgsql error messages more developers' friendly.