Re: BUG #5563: Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo) - Mailing list pgsql-bugs

From Alex Hunsaker
Subject Re: BUG #5563: Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo)
Date
Msg-id AANLkTi=xutTz9GzruVY_aaoTRpnDc_VxCdBb39TjOMA9@mail.gmail.com
Whole thread Raw
In response to BUG #5563: Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo)  ("Daniel Grace" <dgrace@wingsnw.com>)
Responses Re: BUG #5563: Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo)  (Daniel Grace <dgrace@wingsnw.com>)
List 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 by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: BUG #5567: will not install
Next
From: Jeff Davis
Date:
Subject: Re: page corruption after moving tablespace