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

2010-07-18 Thread Tom Lane
"Daniel Grace" 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!

[BUGS] BUG #5564: Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo)

2010-07-16 Thread Daniel Grace
The following bug has been logged online: Bug reference: 5564 Logged by: Daniel Grace Email address: dgr...@wingsnw.com PostgreSQL version: 9.0beta3 Operating system: Windows XP 32-bit Description:Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo) Details: