PostgreSQL bug in SELECT DISTINCT

From: "J(dot)R(dot) Onyschak" <jonyschak(at)nvisia(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: PostgreSQL bug in SELECT DISTINCT
Date: 2001-04-30 19:31:10
Message-ID: 3AEDBD7E.7090002@nvisia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Vivek Khera 2001-04-30 19:51:54 instructions for "register" from make install are misleading
Previous Message Thomas Lockhart 2001-04-30 17:59:34 Re: v7.1.1 branched and released on Tuesday ...