From: Craig Johannsen <cjohan@home.com>
To: pgsql-sql@postgresql.org
Cc: ian.schumacher@telus.net, Francisco Hernandez <xy0xy0@earthlink.net>
Cc: pgsql-general@postgresql.org
Subject: Re: Re: [SQL] variables in SQL??
Date: Thu, 17 Aug 2000 23:12:44 -0700
Message-ID: <399CD3DC.F028B264@home.com> (raw)
References: <000f01c0074f$4dcd87e0$700c2304@francisco>
<399A7D6C.20593252@dohle.com>
You can create a running total provided that you have a unique
sequentially increasing (or decreasing) ID for each row. See the
following example:
create table tran(id int primary key, price dec(8,2));
insert into tran values(1,5.00);
insert into tran values(2,4.00);
insert into tran values(3,10.00);
insert into tran values(4,2.00);
insert into tran values(5,7.00);
select price, (select sum(price) from tran as d1
where d1.id <= d2.id) as "sum"
from tran as d2;
price | sum
-------+-------
5.00 | 5.00
4.00 | 9.00
10.00 | 19.00
2.00 | 21.00
7.00 | 28.00
(5 rows)
Francisco wrote:
> > 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
>
====================================
Craig Johannsen
Critical Path Consulting, Inc.
604-762-1514
http://members.home.net/cjohan/cpath
====================================
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: cjohan@home.com, xy0xy0@earthlink.net, pgsql-general@postgresql.org
Subject: Re: [SQL] variables in SQL??
In-Reply-To: <399CD3DC.F028B264@home.com>
References: <000f01c0074f$4dcd87e0$700c2304@francisco> <399A7D6C.20593252@dohle.com> <399CD3DC.F028B264@home.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox