distinct+trim=error? - Mailing list pgsql-novice

From Boszormenyi Laszlo
Subject distinct+trim=error?
Date
Msg-id Pine.LNX.4.21.0009241528280.28865-100000@jupiter.hlab.uni-miskolc.hu
Whole thread Raw
Responses RE: distinct+trim=error?
List 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


pgsql-novice by date:

Previous
From: Claus Houmøller
Date:
Subject: Re: Case (in)sensitive
Next
From: "Tamsin"
Date:
Subject: RE: distinct+trim=error?