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