| From: | AnthonyV <avequeau(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Advance SQL subquery |
| Date: | 2009-09-23 12:13:34 |
| Message-ID: | d256c59b-97f5-4b37-9142-5fffe41b517c@p36g2000vbn.googlegroups.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
I have a table like :
date | value
-------------------------------
2009-09-19 | 1
2009-09-20 | 2
2009-09-21 | 6
2009-09-22 | 9
2009-09-23 | 1
I'd like a request which gives me the sum of each last n days.
For example, if I want the sum of each 3 days, I want this result:
date | sum_value
-------------------------------
2009-09-19 | 1 (sum from 2009-09-17 to 2009-09-19)
2009-09-20 | 3 (sum from 2009-09-18 to 2009-09-20)
2009-09-21 | 9 (sum from 2009-09-19 to 2009-09-21)
2009-09-22 | 17 (sum from 2009-09-20 to 2009-09-22)
2009-09-23 | 16 (sum from 2009-09-21 to 2009-09-23)
I try to make a subquery which is apply on each row of a query, but it
does work.
Has anybody an idea?
Thanks in advance!
Anthony
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Emi Lu | 2009-09-23 13:34:32 | Re: Graphical representation of query plans |
| Previous Message | Martin Gainty | 2009-09-23 11:26:18 | Re: Re: PL/PG SQL: select count(*) into <var> from <ANY VIEW> where <cond> - does not compute the where cond - returns always total count |