Re: BUG #14344: string_agg(DISTINCT ..) crash

Peter Geoghegan <pg@heroku.com> writes:
> On Thu, Sep 29, 2016 at 5:10 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Hm, works OK for me:
>>
>> regression=# SELECT string_agg(DISTINCT state, ',' ORDER BY state)
>> FROM string_agg_crash_test;
>> string_agg
>> -------------------
>> HI,IL,KS,MA,MA,NY
>> (1 row)

> Actually, it doesn't work for you, since "MA" appears twice. :-(

Hah ... it was too late at night for me to notice that ;-)

> A fix is in the works.

So you've identified the problem and the rest of us don't need to
chase it anymore?

            regards, tom lane