Re: [SQL] variables in SQL?? - Mailing list pgsql-general

From Volker Paul
Subject Re: [SQL] variables in SQL??
Date
Msg-id 399A7D6C.20593252@dohle.com
Whole thread Raw
In response to variables in SQL??  ("Francisco Hernandez" <xy0xy0@earthlink.net>)
List pgsql-general
> 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

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Re[2]: Unimpletmented features
Next
From: e411@altavista.com
Date:
Subject: Tables Question