On Sun, Jun 3, 2012 at 5:56 AM, <shinsetsusan@yahoo.fr> wrote:
> The following bug has been logged on the website:
>
> Bug reference: =A0 =A0 =A06674
> Logged by: =A0 =A0 =A0 =A0 =A0susan
> Email address: =A0 =A0 =A0shinsetsusan@yahoo.fr
> PostgreSQL version: 9.1.3
> Operating system: =A0 windows vista 64b
> Description:
>
> 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
> =A0FROM "GeoNames" WHERE fcode LIKE 'ADM%' GROUP BY iso ORDER BY iso ASC;
It's not clear how the behavior that you're getting is different from
what you expect.
--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company