ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list

From: Gourish Singbal <gourish(at)gmail(dot)com>
To: PgSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
Date: 2005-03-14 10:00:17
Message-ID: 674d1f8a050314020068b6c0c8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

The Query needs to have the distinct clause in the select statement
and the UPPER clause in the order by clause.

eg.
select distinct id, type from user_list order by UPPER(type)

Please let me know if there is any solution to this issue
thanks in advance.
--
Best,
Gourish Singbal

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David Wagoner 2005-03-14 14:37:27 Log to Syslog or rotatelogs? Advice Please
Previous Message 江文 2005-03-14 09:06:51 Do I have to change my Locale or database Encoding to enable LOWER() ?