Re: select distinct and order by

On Thu, 16 Aug 2001 newsreader@mediaone.net wrote:

> Pg complained that select distinct column and
> order by column must be the same.

Depending on what you are doing, you may be able to
use group by with an explicit set value function on
the sort by field (for example:
select foo from table group by foo order by min(bar);)

(I don't know anything about the dbi interface really, so i'll
leave that part for someone who does)