Re: BUG #5563: Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo)

Поиск
Список
Период
Сортировка
От Alex Hunsaker
Тема Re: BUG #5563: Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo)
Дата
Msg-id AANLkTi=xutTz9GzruVY_aaoTRpnDc_VxCdBb39TjOMA9@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #5563: Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo)  ("Daniel Grace" <dgrace@wingsnw.com>)
Ответы Re: BUG #5563: Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo)  (Daniel Grace <dgrace@wingsnw.com>)
Список pgsql-bugs
On Fri, Jul 16, 2010 at 18:04, Daniel Grace <dgrace@wingsnw.com> wrote:
> However, in some circumstances Postgres will fail

How exactly?

this is what I get:
=> SELECT STRING_AGG(DISTINCT t::text order by t::text) FROM foo;
 string_agg
------------
 abc
(1 row)

=> SELECT STRING_AGG(DISTINCT t::text order by t::text desc) FROM foo;
 string_agg
------------
 cba
(1 row)

Maybe its so obvious I missed it?

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

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: BUG #5567: will not install
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: page corruption after moving tablespace