Re: Question regarding modelling for time series
От | Sergey Konoplev |
---|---|
Тема | Re: Question regarding modelling for time series |
Дата | |
Msg-id | CAL_0b1sqEfG9b_eu9A5OaNnbytC=Xmdc-jFcR9n81phGjMu92A@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Question regarding modelling for time series (Alex Grund <st.helldiver@googlemail.com>) |
Список | pgsql-sql |
On Wed, Sep 5, 2012 at 11:39 AM, Alex Grund <st.helldiver@googlemail.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.ru@gmail.com Skype: gray-hemp Phone: +79160686204
В списке pgsql-sql по дате отправления: