[SQL] Sum up network events by type, interval and network

2010-11-16 Thread Axel Rau
Hi all, For each event of each type in each interval I want to compute the sum of events referencing the same relayNet (via host) and insert/update 1 row in SumOfEvents. All intervals start at a time, minimum 5 minutes in the past, rounded down modulo 5 minutes like: SELECT DATE_TRUNC('MI

Re: [SQL] multi table import from 1 denormalized source table

2010-11-16 Thread Jasen Betts
On 2010-11-16, Andreas wrote: > Hi, > > I frequently get tables from spreadsheets to import into the DB. > > Usually it looks like this: > A1, A2, A3, A4, B1, B2, B3, with optional C1, C2, D1, D2, ... > > and there is a 1:n relation between A and B. > If provieded the C would be 1:1 to A and