Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?

"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> Simon Riggs <simon@2ndquadrant.com> writes:
>> Perhaps we can have a parameter?
>> default_null_sorting = 'last' # may alternatively be set to 'first'
>
> Not unless it's locked down at initdb time.  Otherwise flipping the
> value bars you from using every existing index ... including those
> on the system catalogs ... which were made with the other setting.

Surely if we added this we would also add explicit NULLS LAST clauses to all
system catalog indexes and system views and make explicitly constructed scans
in the backend use NULLS LAST.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's 24x7 Postgres support!