Thread: distinct+trim=error?

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

Probably (can't try this at the moment as I'm at home) you need to do:

 select distinct trim(city) from lodge order by trim(city);

Hope this helps
Tamsin

> -----Original Message-----
> From: pgsql-novice-owner@hub.org [mailto:pgsql-novice-owner@hub.org]On
> Behalf Of Boszormenyi Laszlo
> Sent: 24 September 2000 14:43
> To: pgsql-novice@hub.org
> Subject: [NOVICE] distinct+trim=error?
>
>
> 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
>
>