Re: [SQL] Double aggregate problem

2009-07-23 Thread David Weilers
bericht- > Van: Peter Eisentraut [mailto:pete...@gmx.net] > Verzonden: woensdag 22 juli 2009 20:05 > Aan: pgsql-sql@postgresql.org > CC: David Weilers > Onderwerp: Re: [SQL] Double aggregate problem > > On Wednesday 22 July 2009 19:16:21 David Weilers wrote: > > I have the f

Re: [SQL] Double aggregate problem

2009-07-22 Thread nha
Hello, Le 22/07/09 20:04, Peter Eisentraut a écrit : > On Wednesday 22 July 2009 19:16:21 David Weilers wrote: >> 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, tb

Re: [SQL] Double aggregate problem

2009-07-22 Thread nha
Hello, Le 22/07/09 18:16, David Weilers a écrit : > 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

Re: [SQL] Double aggregate problem

2009-07-22 Thread Peter Eisentraut
On Wednesday 22 July 2009 19:16:21 David Weilers wrote: > 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 , > tblvacatur