Обсуждение: BUG #6674: functon aggregat

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

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