Date: Wed, 22 Jul 2009 18:16:21 +0200
From: "David Weilers" <david@lionhead.nl>
To: pgsql-sql <pgsql-sql@postgresql.org>
Message-ID: <H00000670039e901.1248279381.lionhead2.lionhead.nl@MHS>
Subject: Double aggregate problem
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Dear anyone,

I have the following query:

select v.id, array_to_string(array_accum(s.name),', ') as sector ,=20
array_to_string(array_accum(p.name),', ') as provincie from tblvacature=20
v, tblaccount a , tblvacaturesector vs, tblsector s ,=20
tblvacatureprovincie vp, tblprovincie p where v.id =3D 11 and v.account =3D=
=20
a.id and vs.vacature =3D v.id and s.id =3D vs.sector and vp.vacature =3D v=
=2Eid=20
and p.id =3D vp.provincie group by v.id, v.inserted order by v.inserted=20
desc

That currently produces the following output:

id |                      sector                       |                =20

                   provincie
----+---------------------------------------------------+---------------
-------------------------------------------------------------------
 11 | Gaafjes, Eerder, Gaafjes, Eerder, Gaafjes, Eerder | Noord-Holland,=20

Noord-Holland, Limburg, Limburg, Oost-Vlaanderen, Oost-Vlaanderen

If i leave out one aggregate, the result is as i expect (if I leave out=20
'provincie', sector gives):

Gaafjes, Eeerder

Only two results.

I would like both array_accum returning only what they should and not=20
doubles.

Any help is appreciated.

--
Regards,

David Weilers