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
- Re: [BUGS] PostgreSQL bug in SELECT DISTINCT J.R. Onyschak
- Re: [BUGS] PostgreSQL bug in SELECT DISTINCT Tom Lane
- Re: [BUGS] PostgreSQL bug in SELECT DISTINCT J.R. Onyschak