RE: distinct+trim=error?

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(at)hub(dot)org [mailto:pgsql-novice-owner(at)hub(dot)org]On
> Behalf Of Boszormenyi Laszlo
> Sent: 24 September 2000 14:43
> To: pgsql-novice(at)hub(dot)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
>
>