Configure default for sorting of null-values?

From: Rob Gansevles <rgansevles(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Configure default for sorting of null-values?
Date: 2010-09-01 08:05:19
Message-ID: AANLkTi=ncurUP0DXj+jZnAmYmo5WPph3+BNLO5PkGMiV@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adarsh Sharma 2010-09-01 10:13:21 Problem in getting Output
Previous Message Raymond C. Rodgers 2010-09-01 00:28:28 Re: Table update problem works on MySQL but not Postgres