Hi, On 6 September 2010 16:18, Angus Miller <all4miller@xxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) > 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: gray.ru@xxxxxxxxx / Skype: gray-hemp / ICQ: 29353802 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
