Re: Bug with ordering aggregates?

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Bug with ordering aggregates?
Дата
Msg-id 20100518164217.GI21875@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Bug with ordering aggregates?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Bug with ordering aggregates?  (Caleb Welton <cwelton@greenplum.com>)
Список pgsql-hackers
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Stephen Frost <sfrost@snowman.net> writes:
> >   This doesn't seem right to me:
>
> > postgres=# select
> > postgres-# string_agg(column1::text order by column1 asc,',')
> > postgres-# from (values (3),(4),(1),(2)) a;
> >  string_agg
> > ------------
> >  1234
> > (1 row)
>
> Looks fine to me: you have two ordering columns (the second rather
> useless,  but that's no matter).

Ah, yeah, guess I'll just complain that having the order by look like
it's an argument to an aggregate makes things confusing.  Not much to be
done about it though.
Thanks,
    Stephen

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: Bug with ordering aggregates?
Следующее
От: Stephen Frost
Дата:
Сообщение: Documentation Bug/Misnomer?