Postgres Pro
Downloads
Home   >   mailing lists

ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list - Mailing list pgsql-admin

From Gourish Singbal
Subject ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
Date
Msg-id 674d1f8a050314020068b6c0c8@mail.gmail.com
Whole thread Raw
Responses Re: ERROR: for SELECT DISTINCT, ORDER BY expressions must
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Mitchell Laks
Date:
Subject: Re: Severe Badness On My Server: psql: FATAL: the database
Next
From: David Wagoner
Date:
Subject: Log to Syslog or rotatelogs? Advice Please