Postgres Pro
Downloads
Home   >   mailing lists

Re: Rough impl of IGNORE NULLS for window functions - Mailing list pgsql-hackers

From David Fetter
Subject Re: Rough impl of IGNORE NULLS for window functions
Date
Msg-id 20110913221732.GD14038@fetter.org
Whole thread Raw
In response to Rough impl of IGNORE NULLS for window functions  (Joe Banafato <joe@banafato.com>)
List pgsql-hackers
Tree view 
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@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.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

pgsql-hackers by date:

Previous
From: Josh Kupershmidt
Date:
Subject: foreign table: WARNING: problem in alloc set ExecutorState detected write past chunk end in block ...
Next
From: Tom Lane
Date:
Subject: Re: foreign table: WARNING: problem in alloc set ExecutorState detected write past chunk end in block ...