Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 54B1E9FB5F3 for ; Tue, 17 Jul 2007 04:14:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 46958-02 for ; Tue, 17 Jul 2007 04:14:23 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175]) by postgresql.org (Postfix) with ESMTP id 8EE059FB9C9 for ; Tue, 17 Jul 2007 04:14:26 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so100970ugf for ; Tue, 17 Jul 2007 00:14:24 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=CDmciEZ358CngLKwXll8vQ3OOQneK0faNjyhQVdqjnCMeJrnr0p3b0fLOPf4YMEXIJGpBtSQywJy7w4/RW17FSnAhozq+Lm7j5m/1N2w6qEuewcfaPePkW0cd4sZ9g2psS41NPemb1NJ1q0ToY7830yA4+CVuU3nFTs3l1Pys8I= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=Y79pbYzOkec6GB9XlfW5Lew8yIfCLTqTZLP16OiJGhVt/J78Wfw3hCaThXXwehuNFrzjL9Oinph8dOCiq1qdOrHS5Qiumwf8Uv+Eau0+NyL8bUkJAoPkc2x1aouM4wPVSSCR6tmMSkJ5pbiar5cV3taC98qGRVmB5vHN4QRkgWs= Received: by 10.67.92.1 with SMTP id u1mr122833ugl.1184656464477; Tue, 17 Jul 2007 00:14:24 -0700 (PDT) Received: from ?192.168.10.68? ( [62.57.108.235]) by mx.google.com with ESMTPS id k57sm1779672uga.2007.07.17.00.14.23 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 17 Jul 2007 00:14:24 -0700 (PDT) Message-ID: <469C6C4A.3040201@gmail.com> Date: Tue, 17 Jul 2007 09:14:18 +0200 From: =?ISO-8859-1?Q?Dani_Casta=F1os?= User-Agent: Thunderbird 2.0.0.4 (Windows/20070604) MIME-Version: 1.0 CC: pgsql-sql@postgresql.org Subject: Re: Having the sum of two queries References: <469B512D.70507@gmail.com> <001401c7c7f4$c4515280$6200a8c0@hmv02> In-Reply-To: <001401c7c7f4$c4515280$6200a8c0@hmv02> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/97 X-Sequence-Number: 28832 Thank you all! My problem has been solved in another way... because the inner queries had left outer joins and so on, and I finally have had to do two queries and treat results by PHP. Again... thank you all!