Re: Rough impl of IGNORE NULLS for window functions

From: David Fetter <david(at)fetter(dot)org>
To: Joe Banafato <joe(at)banafato(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Rough impl of IGNORE NULLS for window functions
Date: 2011-09-13 22:17:32
Message-ID: 20110913221732.GD14038@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Sep 13, 2011 at 04:18:48AM -0400, Joe Banafato wrote:
> Hi all,
>
> I wrote an implementation of last_value that ignores null values,
> effectively achieving the behavior of last_value(<exp> ignore nulls).
> The code is up on BitBucket [1] for the moment.  Thoughts:

Just in case of lossage on bitbucket, could you please send a patch
vs. git master to the list?

Cheers,
David (pretty excited about this feature).
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-09-13 22:29:41 Re: foreign table: WARNING: problem in alloc set ExecutorState detected write past chunk end in block ...
Previous Message Josh Kupershmidt 2011-09-13 22:11:34 foreign table: WARNING: problem in alloc set ExecutorState detected write past chunk end in block ...