Received: from gate.experian.it (IDENT:qmailr@gate.experian.it [212.210.24.10]) by hub.org (8.9.2/8.9.1) with SMTP id MAA10732 for ; Tue, 9 Feb 1999 12:31:26 -0500 (EST) (envelope-from ludo@experian.it) Received: (qmail 14776 invoked from network); 9 Feb 1999 17:31:09 -0000 Received: from unknown (HELO deskproludo) (192.168.11.105) by gate.experian.it with SMTP; 9 Feb 1999 17:31:09 -0000 Message-ID: <004f01be5451$f4b158a0$140aa8c0@deskproludo> From: "Ludovico Magnocavallo" To: "Jackson, DeJuan" , Cc: "PGSQL SQL" Subject: Re: [GENERAL] pqReadData() -- backend closed the channel unexpect edly. Date: Tue, 9 Feb 1999 18:30:57 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.0810.800 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0810.800 Thanks a lot for your suggestion, that in fact gets me through the loop. Only problem is, I need to group by origine and get that sum(bytes) and by destinazione and get that sum(bytes). They are different. Your statement only groups for origine (in fact it groups by address, which is non-existent in the day table, and gets me null values). In the meantime, I have discovered that the number of queries is irrelevant to the crash, the crash happens in the INSERT statement when the datetime field is set to 12:00:00 or 12:59:59 or whatever, but always at 12. Ludo