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 AA476D1B1D2 for ; Mon, 2 Aug 2004 08:27:00 -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 59772-08 for ; Mon, 2 Aug 2004 11:27:00 +0000 (GMT) Received: from mail.interzone.gr (server.interzone.gr [193.41.229.197]) by svr1.postgresql.org (Postfix) with ESMTP id 4FDF1D1B18A for ; Mon, 2 Aug 2004 08:26:55 -0300 (ADT) Received: by mail.interzone.gr (Postfix, from userid 1005) id E99AF1AC2E; Mon, 2 Aug 2004 14:26:54 +0300 (EEST) Received: from [192.168.0.5] (ppp1-161.ath.forthnet.gr [213.16.144.161]) by mail.interzone.gr (Postfix) with ESMTP id E24411AC16; Mon, 2 Aug 2004 14:26:49 +0300 (EEST) Message-ID: <410E25E7.9000809@interzone.gr> Date: Mon, 02 Aug 2004 14:30:47 +0300 From: Michalis Kabrianis Organization: Interzone User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7) Gecko/20040616 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Sum and count weird results Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=RCVD_IN_NJABL, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200408/32 X-Sequence-Number: 18529 Hi all, I have these tables a ( id integer, email varchar); b ( seat varchar, transactionid varchar); c ( transactionid varchar, totalprice numeric(8.2));