Re: Configure default for sorting of null-values?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rob Gansevles <rgansevles(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Configure default for sorting of null-values?
Date: 2010-09-07 14:32:55
Message-ID: 9563.1283869975@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rob Gansevles <rgansevles(at)gmail(dot)com> writes:
> Does anyone know if this is configurable?
> Or should I file a feature request?

It is not, and a feature request is probably going to go nowhere.
The reason configurability seems like a bad idea is that null sort
direction is wired into things like index contents. If a user
were to flip the default null sort direction locally to his session,
then suddenly most of the indexes in the system would become unusable
to him. No doubt there are things that could be done to ameliorate
that, but overall it's just not apparent that the cost/benefit ratio
is reasonable for such a change.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Henk van Lingen 2010-09-07 14:48:50 Re: Forcing the right queryplan
Previous Message Guillaume Lelarge 2010-09-07 08:09:36 Re: Configure default for sorting of null-values?