Re: any way for ORDER BY x to imply NULLS FIRST in 8.3? - Mailing list pgsql-general

From Tom Lane
Subject Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?
Date
Msg-id 16585.1194448986@sss.pgh.pa.us
Whole thread Raw
In response to Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?
Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?
List pgsql-general
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.

I put this in the same category as altering the identifier case-folding
rules.  Yeah, it'd be great to be all things to all people, but the
implementation pain and risk of breakage of existing applications
isn't worth it.

            regards, tom lane

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Temporary, In-memory Postgres DB?
Next
From: Karsten Hilbert
Date:
Subject: Re: md5() sorting