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 9BD9552A37
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  5 Aug 2005 15:05: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 13978-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  5 Aug 2005 18:05:43 +0000 (GMT)
Received: from boutiquenumerique.com (boutiquenumerique.com [82.67.9.10])
	by svr1.postgresql.org (Postfix) with ESMTP id 25366528D4
	for <pgsql-sql@postgresql.org>; Fri,  5 Aug 2005 15:05:42 -0300 (ADT)
Received: (qmail 26714 invoked from network); 5 Aug 2005 20:05:52 +0200
Received: from unknown (HELO localhost) (boutiquenumerique-lists@192.168.0.4)
	by boutiquenumerique.com with SMTP; 5 Aug 2005 20:05:52 +0200
To: "Henry Ortega" <juandelacruz@gmail.com>, 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>
Message-ID: <op.su1q7r0lth1vuj@localhost>
From: PFC <lists@boutiquenumerique.com>
Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?=
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Date: Fri, 05 Aug 2005 20:05:41 +0200
In-Reply-To: <2bffcc3305080510535e3c81ef@mail.gmail.com>
User-Agent: Opera M2/8.0 (Linux, build 1095)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200508/30
X-Sequence-Number: 22258

On Fri, 05 Aug 2005 19:53:14 +0200, Henry Ortega <juandelacruz@gmail.com>  
wrote:

> Is it possible at all to do this without any joins
> or subselect?

	I don't think so.
	You could always hide them in a view...