| From: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
|---|---|
| To: | Alex Grund <st(dot)helldiver(at)googlemail(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Question regarding modelling for time series |
| Date: | 2012-09-05 09:13:57 |
| Message-ID: | CAL_0b1sqEfG9b_eu9A5OaNnbytC=Xmdc-jFcR9n81phGjMu92A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Wed, Sep 5, 2012 at 11:39 AM, Alex Grund <st(dot)helldiver(at)googlemail(dot)com> wrote:
> Since the data is not revised further than one month behind, the whole
> series ex-post would look like that: [3]
> Unemployment; release: 2011/12/01; reporting: 2011/11/01; value: 1
> Unemployment; release: 2011/12/01; reporting: 2011/10/01; value: 2.5
> Unemployment; release: 2011/11/01; reporting: 2011/09/01; value: 3.5
> Unemployment; release: 2011/10/01; reporting: 2011/08/01; value: 4.5
> Unemployment; release: 2011/09/01; reporting: 2011/07/01; value: 5.5
As I understand 3 it is just a UNION of 1 and 2.
>
> Whereas, the "known-to-market"-series would look like that: [2]
>
> Unemployment; release: 2011/12/01; reporting: 2011/11/01; value: 1
> Unemployment; release: 2011/11/01; reporting: 2011/10/01; value: 2
> Unemployment; release: 2011/10/01; reporting: 2011/09/01; value: 3
> Unemployment; release: 2011/09/01; reporting: 2011/08/01; value: 4
>
> That are the series I want to get from the db.
>
>
> --Alex
--
Sergey Konoplev
a database and software architect
http://www.linkedin.com/in/grayhemp
Jabber: gray(dot)ru(at)gmail(dot)com Skype: gray-hemp Phone: +79160686204
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yelai, Ramkumar IN BLR STS | 2012-09-06 12:23:08 | Re: Need to Iterate the record in plpgsql |
| Previous Message | Alex Grund | 2012-09-05 07:39:20 | Re: Question regarding modelling for time series |