Received: from odysseus1.dohle.com (root@odysseus1.dohle.com [194.127.185.21]) by hub.org (8.10.1/8.10.1) with ESMTP id e7GBXKn96834; Wed, 16 Aug 2000 07:33:20 -0400 (EDT) Received: from majestix.dohle.com (majestix.dohle.com [194.127.190.1]) by odysseus1.dohle.com (8.9.3/8.9.3) with SMTP id NAA25189; Wed, 16 Aug 2000 13:33:18 +0200 Received: from wpaul.dohle.com by majestix.dohle.com id aa22886; 16 Aug 100 13:33 CETDST Message-ID: <399A7D6C.20593252@dohle.com> Date: Wed, 16 Aug 2000 13:39:24 +0200 From: Volker Paul Organization: Dohle Handelsgruppe Systemberatung GmbH X-Mailer: Mozilla 4.05 [en] (WinNT; I) MIME-Version: 1.0 To: Francisco Hernandez CC: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: [SQL] variables in SQL?? References: <000f01c0074f$4dcd87e0$700c2304@francisco> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/365 > what im trying to do is have a Sum of a colum.. as it goes forwards with the > cursor.. > like so: > > Price|Sum > 5|5 > 4|9 > 10|19 > 2|21 > 7|28 I think what you mean is called running sum, I had the same problem before, and I found no other solution than creating a column for it, and calculating its values by a function. Yours, V.Paul