On Wed, Nov 07, 2007 at 02:37:41PM +0000, Simon Riggs wrote:
> Editing an application, you would be required to add the words NULLS
> FIRST to every single ORDER BY and every single CREATE INDEX in an
> application. If we know that is what people would do, why not have one
> parameter to do this for them?
I find it hard to beleive that every single query in an application
depends on the ordering of NULLs. In fact, I don't think I've even
written a query that depended on a particular way of sorting NULLs. Is
it really that big a deal?
> Implement SQLServer and MySQL behaviour? Now we're talking about
> hundreds of new applications that might decide to migrate/support
> PostgreSQL because of our flexibility in being able to support both
> kinds of sorting.
TBH I think long term is should be attached to each column, as it is a
property of the collation (my COLLATE patch let you specify it per
column).
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy
