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. :-(
A fix is in the works.
--
Peter Geoghegan