Double aggregate problem

From: "David Weilers" <david(at)lionhead(dot)nl>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Double aggregate problem
Date: 2009-07-22 16:16:21
Message-ID: H00000670039e901.1248279381.lionhead2.lionhead.nl@MHS
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dear anyone,

I have the following query:

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

That currently produces the following output:

id | sector |

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

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

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

Gaafjes, Eeerder

Only two results.

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

Any help is appreciated.

--
Regards,

David Weilers

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message nha 2009-07-22 17:45:58 Re: Double aggregate problem
Previous Message Frank Bax 2009-07-22 11:42:09 Re: how to tell if column set on update