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

From: Alex Hunsaker <badalex(at)gmail(dot)com>
To: Daniel Grace <dgrace(at)wingsnw(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5563: Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo)
Date: 2010-07-23 17:42:22
Message-ID: AANLkTi=xutTz9GzruVY_aaoTRpnDc_VxCdBb39TjOMA9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Jul 16, 2010 at 18:04, Daniel Grace <dgrace(at)wingsnw(dot)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?

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Davis 2010-07-23 18:05:51 Re: page corruption after moving tablespace
Previous Message Stefan Kaltenbrunner 2010-07-23 17:29:36 Re: BUG #5567: will not install