Received: from odysseus2.dohle.com (root@odysseus2.dohle.com [194.127.185.20]) by hub.org (8.10.1/8.10.1) with ESMTP id e6L97Ah29248 for ; Fri, 21 Jul 2000 05:07:11 -0400 (EDT) Received: from majestix.dohle.com (majestix.dohle.com [194.127.190.1]) by odysseus2.dohle.com (8.9.3/8.9.3) with SMTP id LAA16285; Fri, 21 Jul 2000 11:07:04 +0200 Received: from wpaul.dohle.com by majestix.dohle.com id aa00185; 21 Jul 100 11:07 CETDST Message-ID: <3978139A.3F12604F@dohle.com> Date: Fri, 21 Jul 2000 11:10:50 +0200 From: Volker Paul Organization: Dohle Handelsgruppe Systemberatung GmbH X-Mailer: Mozilla 4.05 [en] (WinNT; I) MIME-Version: 1.0 To: poange@technologist.com CC: pgsql-sql@postgresql.org Subject: Re: problem with view and case - please help References: <39780EEE.BBCB6406@technologist.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200007/199 > CREATE VIEW browser > AS > SELECT > agent_i, > CASE > WHEN agent_i LIKE '%MSIE 2.0;%' THEN 'Internet Explorer 2.0' > ... > agent_i NOT LIKE '%compatible%' THEN 'Netscape' > WHEN agent_i LIKE 'Mozilla/5.0 %' AND agent_i NOT LIKE '%MSIE%' AND > agent_i NOT LIKE '%compatible%' THEN 'Netscape' > WHEN agent_i LIKE 'Mozilla/6.0 %' AND agent_i NOT LIKE '%MSIE%' AND > agent_i NOT LIKE '%compatible%' THEN 'Netscape' > ELSE agent_i END AS navigateur, count (agent_i) > as total from access group by agent_i; > pqReadData() -- backend closed the channel unexpectedly. > This probably means the backend terminated abnormally > before or while processing the request. > We have lost the connection to the backend, so further processing is > impossible. Terminating. Query limit exceeded? At least that CASE statement looks rather clumsy, suggest using a function instead. V.Paul