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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate