Re: DISTINCT ... ORDER BY - Mailing list pgsql-novice

From Stephan Szabo
Subject Re: DISTINCT ... ORDER BY
Date
Msg-id 20031105131518.C12206@megazone.bigpanda.com
Whole thread Raw
In response to Re: DISTINCT ... ORDER BY  (Nabil Sayegh <postgresql@e-trolley.de>)
Responses Re: DISTINCT ... ORDER BY  (Nabil Sayegh <postgresql@e-trolley.de>)
List pgsql-novice
On Wed, 5 Nov 2003, Nabil Sayegh wrote:

> Stephan Szabo wrote:
>
> > Your step 3 above isn't well defined in general.  There's no single place
> > in the sort order for a value of a column being distincted when the value
> > occurs multiple times.  In the data above, col1='b' occurs twice in the
> > sort order and you need to give an indication of which place in the sort
> > order you want to use.
>
> Ok, let's look for alternatives.

Well, what did you get when you tried something like Bruno's updated
example or my group by one, and lets work from there.

pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: DISTINCT ... ORDER BY
Next
From: Nabil Sayegh
Date:
Subject: Re: DISTINCT ... ORDER BY