Re: select distinct and order by - Mailing list pgsql-general

From newsreader@mediaone.net
Subject Re: select distinct and order by
Date
Msg-id 20010816061621.B1099@dragon.universe
Whole thread Raw
In response to Re: select distinct and order by  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
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@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)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

pgsql-general by date:

Previous
From: "Ben-Nes Michael"
Date:
Subject: Roll Back dont roll back counters
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Roll Back dont roll back counters