[BUGS] PostgreSQL bug in SELECT DISTINCT

[J.R. Onyschak]

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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster