Thanks Sergery that's what I was after.
1 2010/01/01 On Mon, Sep 6, 2010 at 2:29 PM, Sergey Konoplev <[email protected]> wrote: > Hi, > > On 6 September 2010 16:18, Angus Miller <[email protected]> wrote: >> How can I generate result-set that will carry the previous records >> values through till a new event occurred so there is a record for each >> "day"? > > If I understand the problem correct you need to use generate_series() > function (http://www.postgresql.org/docs/8.4/interactive/functions-srf.html). > Just join your data to its result set. > >> >> Cheers >> Angus >> >> -- >> Sent via pgsql-general mailing list ([email protected]) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > > > > -- > Sergey Konoplev > > Blog: http://gray-hemp.blogspot.com / > Linkedin: http://ru.linkedin.com/in/grayhemp / > JID/GTalk: [email protected] / Skype: gray-hemp / ICQ: 29353802 > -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
