BUG #6674: functon aggregat - Mailing list pgsql-bugs

From shinsetsusan@yahoo.fr
Subject BUG #6674: functon aggregat
Date
Msg-id E1Sb7YD-0002DF-IT@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #6674: functon aggregat
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6674
Logged by:          susan
Email address:      shinsetsusan@yahoo.fr
PostgreSQL version: 9.1.3
Operating system:   windows vista 64b
Description:=20=20=20=20=20=20=20=20

Hi,
when i use string_agg without DISTINCT, this function return somes empty
aggregate row result But not with DISTINCT.
To reproduce it, use Geoname database from geonames.org with this request

SELECT iso, string_agg(DISTINCT fcode, ',') as n
  FROM "GeoNames" WHERE fcode LIKE 'ADM%' GROUP BY iso ORDER BY iso ASC;=20

pgsql-bugs by date:

Previous
From: Anna Zaks
Date:
Subject: Re: BUG #6672: Memory leaks in dumputils.c
Next
From:
Date:
Subject: Calling xlst_process with certain arguments causes server crash