Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id LAA12710; Thu, 15 Jul 1999 11:11:18 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id LAA06421; Thu, 15 Jul 1999 11:07:10 -0400 (EDT) To: Michael Richards cc: sql@postgreSQL.org, hackers@postgreSQL.org Subject: Re: [HACKERS] Counting bool flags in a complex query In-reply-to: Your message of Wed, 14 Jul 1999 13:34:33 -0300 (ADT) Date: Thu, 15 Jul 1999 11:07:10 -0400 Message-ID: <6419.932051230@sss.pgh.pa.us> From: Tom Lane Michael Richards writes: > I'm not sure this is correct, but I think I see a bug of some sort... > SELECT folderid,foldername,count(*),sum(contentlength),sum(case when > flagnew = TRUE then 1 else 0 end) FROM usermail,folders WHERE > usermail.loginid='michael' and folders.loginid=usermail.loginid AND > usermail.folder = folders.folderid GROUP BY folderid,foldername UNION > SELECT folderid,foldername,0,0,0 FROM folders WHERE loginid='michael' AND > NOT EXISTS (SELECT folder FROM usermail WHERE loginid='michael' AND > folder=folderid) ; > ERROR: _finalize_primnode: can't handle node 723 I committed a fix last night; it will be in 6.5.1. regards, tom lane