From: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
---|---|
To: | Angus Miller <all4miller(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Temporal'sh type sql question |
Date: | 2010-09-06 12:29:02 |
Message-ID: | AANLkTim+ibirJJfqhb_xjqANTBnzJ9X=o+oWiEZg1E+r@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
On 6 September 2010 16:18, Angus Miller <all4miller(at)gmail(dot)com> 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(at)postgresql(dot)org)
> 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(dot)ru(at)gmail(dot)com / Skype: gray-hemp / ICQ: 29353802
From | Date | Subject | |
---|---|---|---|
Next Message | Angus Miller | 2010-09-06 12:57:28 | Re: Temporal'sh type sql question |
Previous Message | Angus Miller | 2010-09-06 12:18:52 | Temporal'sh type sql question |