X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5986552C91 for ; Sun, 7 Aug 2005 03:55:48 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01568-02 for ; Sun, 7 Aug 2005 06:55:42 +0000 (GMT) Received: from priv-edtnes56.telusplanet.net (outbound01.telus.net [199.185.220.220]) by svr1.postgresql.org (Postfix) with ESMTP id E61A052BEA for ; Sun, 7 Aug 2005 03:55:40 -0300 (ADT) Received: from localhost ([199.185.220.240]) by priv-edtnes56.telusplanet.net (InterMail vM.6.01.04.04 201-2131-118-104-20050224) with ESMTP id <20050807065541.EWZN23413.priv-edtnes56.telusplanet.net@localhost> for ; Sun, 7 Aug 2005 00:55:41 -0600 Received: from 64.180.27.185 ( [64.180.27.185]) as user a3a18850@192.168.200.1 by webmail.telus.net with HTTP; Sat, 6 Aug 2005 23:55:41 -0700 Message-ID: <1123397741.42f5b06d5f0d3@webmail.telus.net> Date: Sat, 6 Aug 2005 23:55:41 -0700 From: Mischa Sandberg To: pgsql-sql@postgresql.org Subject: Re: sum but not grouped by? References: <2bffcc33050805092862a01b93@mail.gmail.com> <1123260475.42f3983bafe6d@webmail.telus.net> <2bffcc3305080510535e3c81ef@mail.gmail.com> In-Reply-To: <2bffcc3305080510535e3c81ef@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.1-cvs X-Originating-IP: 64.180.27.185 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.062 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_POST, FORGED_RCVD_HELO X-Spam-Level: * X-Archive-Number: 200508/39 X-Sequence-Number: 22267 Quoting Henry Ortega : > Is it possible at all to do this without any joins > or subselect? Nope. But I'm curious why you make that a condition?