The following bug has been logged on the website:
Bug reference: 6674
Logged by: susan
Email address: shinsetsusan(at)yahoo(dot)fr
PostgreSQL version: 9.1.3
Operating system: 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
FROM "GeoNames" WHERE fcode LIKE 'ADM%' GROUP BY iso ORDER BY iso ASC;