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?
maybe I'm missunderstanding your question but tom implemented that already in -HEAD: http://archives.postgresql.org/pgsql-committers/2007-01/msg00123.php Stefan ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match