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 <[EMAIL PROTECTED]> http://svana.org/kleptog/ > Those who make peaceful revolution impossible will make violent revolution > inevitable. > -- John F Kennedy
signature.asc
Description: Digital signature
