Re: select distinct and order by

Thanks. I don't know much about grouping but
I will now study that thing

On Wed, Aug 15, 2001 at 10:56:33PM -0700, Stephan Szabo wrote:
>
> On Thu, 16 Aug 2001 newsreader(at)mediaone(dot)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)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org