On Wed, Oct 29, 2014 at 12:04 PM, Kirk Roybal <kirk(at)webfinish(dot)com> wrote:
> This [custom aggregate gapfill] is a pretty elegant way of getting there.
>
> It also does a better job of respecting the window frame.
>
> I'll use this until this
> https://commitfest.postgresql.org/action/patch_view?id=1096 shows up.
Yes. In fact it turns out you can implement all kinds of things
including gaps in standards support by via the combination of windows
functions + custom aggregates. Performance is pretty good but not
great.
merlin