Re: Planning aggregates which require sorted or distinct

From: Gavin Sherry <swm(at)alcove(dot)com(dot)au>
To: Karen Hill <karen_hill22(at)yahoo(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Planning aggregates which require sorted or distinct
Date: 2007-01-19 22:34:45
Message-ID: Pine.LNX.4.58.0701200931360.11638@linuxworld.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, 19 Jan 2007, Karen Hill wrote:

> Gavin Sherry wrote:
> > Recenly, I've been researching and putting together a proposal for window
> > functions.
>
> Implementing NULLS FIRST and NULLS LAST appears like another
> challenging step to getting window functions wrapped up. Has your
> research lead you to any ideas on what your strategy for NULLS FIRST
> and NULLS LAST likely would be?

Explicit handling of NULL is only in the Oracle extension to window
functions. I will look at the core SQL functionality first -- maybe with
the extension of 'LEAD' and 'LAG' because they are heavily utilitised by
those using window functions.

Besides, Tom's been working on NULLS FIRST/LAST already.

gavin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Russell Smith 2007-01-19 22:41:33 Re: [HACKERS] Autovacuum Improvements
Previous Message Bruce Momjian 2007-01-19 22:31:29 Re: [PATCHES] [HACKERS] [Fwd: Index Advisor]