On Wed, Oct 29, 2014 at 12:04 PM, Kirk Roybal <k...@webfinish.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers