distinct+trim=error?

From: Boszormenyi Laszlo <gcs(at)jupiter(dot)hlab(dot)uni-miskolc(dot)hu>
To: pgsql-novice(at)hub(dot)org
Subject: distinct+trim=error?
Date: 2000-09-24 13:43:07
Message-ID: Pine.LNX.4.21.0009241528280.28865-100000@jupiter.hlab.uni-miskolc.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello!

First, thanks for everybody who helped me with my previous problem.
Now I have an other, and I can not figure out why this happens.
Any idea?

=> select distinct trim(city) from lodge order by city;
ERROR: For SELECT DISTINCT, ORDER BY expressions must appear in target list

Cheers,
Laszlo

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tamsin 2000-09-24 13:45:47 RE: distinct+trim=error?
Previous Message Claus Houmøller 2000-09-23 17:41:01 Re: Case (in)sensitive