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