Re: select distinct and order by

Поиск
Список
Период
Сортировка
От newsreader@mediaone.net
Тема Re: select distinct and order by
Дата
Msg-id 20010816061621.B1099@dragon.universe
обсуждение исходный текст
Ответ на Re: select distinct and order by  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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 по дате отправления:

Предыдущее
От: "Ben-Nes Michael"
Дата:
Сообщение: Roll Back dont roll back counters
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Roll Back dont roll back counters