[SQL] Foreign key constraint referencing a parent table

2010-05-04 Thread David Weilers
Hi, I have a problem when inserting rows into my table tblfactuurpost that references a table tblfactuur which is a parent to tblclientfactuur. The actual row is inserted into tblfactuur. The problem is that i cannot insert the row into tblfactuurpost (which references the parent table tblfac

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

[SQL] Double aggregate problem

2009-07-22 Thread David Weilers
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 W