PostgreSQL bug in SELECT DISTINCT

J.R. Onyschak <jonyschak@nvisia.com>

From: "J.R. Onyschak" <jonyschak@nvisia.com>
To: pgsql-bugs@postgresql.org
Date: 2001-04-30T19:31:10Z
Lists: pgsql-bugs
When I execute the following query:

SELECT DISTINCT title FROM division ORDER BY UPPER(title);

I get:
ERROR:  For SELECT DISTINCT, ORDER BY expressions must appear in target list

If I remove DISTINCT, the query works fine.

Is this illegal or a known bug?

thanks for any help,
J.R.

PostgreSQL 7.1
Mandrake 8.0