Re: BUG #5564: Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo) - Mailing list 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