The following bug has been logged on the website: Bug reference: 6674 Logged by: susan Email address: shinsetsu...@yahoo.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; -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs