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 839DB52888 for ; Fri, 5 Aug 2005 13:28:34 -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 64701-04 for ; Fri, 5 Aug 2005 16:28:26 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.202]) by svr1.postgresql.org (Postfix) with ESMTP id AD5FF52883 for ; Fri, 5 Aug 2005 13:28:25 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id i8so609186wra for ; Fri, 05 Aug 2005 09:28:25 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=GKhzeZ08gUHfmWZb+xHBFEqr0/KPn4jbb0WP2QazTq76Nz4pfJJZcsKT0ut/5WaeqX6cNCEkitEwIkApIYvrnDDVvPM2Z359dnRhZR1UR/tCQ4a49ls+ZBN2b2AHCu7bUNLHhbUR2AGV52NbgCQBhzVOa0GnJdsBSBCiabMjWG0= Received: by 10.54.46.30 with SMTP id t30mr2693763wrt; Fri, 05 Aug 2005 09:28:24 -0700 (PDT) Received: by 10.54.124.17 with HTTP; Fri, 5 Aug 2005 09:28:24 -0700 (PDT) Message-ID: <2bffcc33050805092862a01b93@mail.gmail.com> Date: Fri, 5 Aug 2005 12:28:24 -0400 From: Henry Ortega Reply-To: Henry Ortega To: pgsql-sql@postgresql.org Subject: sum but not grouped by? Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200508/27 X-Sequence-Number: 22255 I have the ff data: id | date | hours AAA 07-01-2005 3 AAA 07-02-2005 4 BBB 07-01-2005 6 BBB 07-02-2005 2 BBB 07-03-2005 7 Would it be possible to get the ff: id | date | hours | id_total AAA 07-01-2005 3 7 AAA 07-02-2005 4 7 BBB 07-01-2005 6 15 BBB 07-02-2005 2 15 BBB 07-03-2005 7 15 So it's like SUM OF, but not Grouped By? Is this possible at all? Thank you for any help.