Re: [SQL] Need to Iterate the record in plpgsql

2012-09-05 Thread Yelai, Ramkumar IN BLR STS
Hi Pavel, Thanks for the links, but due to the project schedules I have changed procedure logic to use array in iteration instead of records. However, the trigger logic is really good but it seems slow as you said. The blog is really good source to understand plpgsql in better way. Thanks & Re

Re: [SQL] Question regarding modelling for time series

2012-09-05 Thread Sergey Konoplev
On Wed, Sep 5, 2012 at 11:39 AM, Alex Grund 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; va

Re: [SQL] Question regarding modelling for time series

2012-09-05 Thread Alex Grund
Sergey, thank you very much for your hints, I will play a bit with that and maybe come back to the list. Just for clarification, I attached some more explanation and examples below. 2012/9/5 Sergey Konoplev : > I am not quite understand what is meant here. Could you please provide > more explana