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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5564: Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo)
Дата
Msg-id 19293.1279482033@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #5564: Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo)  ("Daniel Grace" <dgrace@wingsnw.com>)
Список pgsql-bugs
"Daniel Grace" <dgrace@wingsnw.com> writes:
> This test case fails with the above error:

> CREATE TABLE foo (
>     t VARCHAR
> );

> INSERT INTO foo (t) VALUES ('a'), ('a'), ('b'), ('b'), ('c');

> SELECT STRING_AGG(DISTINCT t ORDER BY t) FROM foo;

I've applied a patch for this.  Thanks for the report!

            regards, tom lane

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