Re: Configure default for sorting of null-values?

From: Rob Gansevles <rgansevles(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Configure default for sorting of null-values?
Date: 2010-09-07 07:57:20
Message-ID: AANLkTik0YxNfov54jChHs-60=0_UiYXE71k=KRgX0H05@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Does anyone know if this is configurable?

Or should I file a feature request?

Rob

On Wed, Sep 1, 2010 at 10:05 AM, Rob Gansevles <rgansevles(at)gmail(dot)com> wrote:
> Hi,
>
> From the docs I see that you can control null values being sorted
> before or after all non-null-values using 'NULLS LAST' or 'NULLS
> FIRST' in the order by clause.
>
> The default behaviour is to act as though nulls are larger than non-nulls.
>
> My question is, is there a way to configure this default, at
> connection level or at server level?
>
> Thanks,
>
> Rob
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kurt 2010-09-07 07:59:48 Re: does record_eq() ignore user-defined operators?
Previous Message Joshua D. Drake 2010-09-06 18:16:47 Re: FC13 RPMs for 9.0 - on postgresql.org ftp, but not in yum repo?