PostgreSQL bug in SELECT DISTINCT - Mailing list pgsql-bugs

From J.R. Onyschak
Subject PostgreSQL bug in SELECT DISTINCT
Date
Msg-id 3AEDBD7E.7090002@nvisia.com
Whole thread Raw
Responses Re: PostgreSQL bug in SELECT DISTINCT  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-bugs by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: 7.1 euro-style dates insert error
Next
From: Nick Gazaloff
Date:
Subject: ...