Postgres Pro
Downloads
Home   >   mailing lists

Configure default for sorting of null-values? - Mailing list pgsql-general

From Rob Gansevles
Subject Configure default for sorting of null-values?
Date
Msg-id AANLkTi=ncurUP0DXj+jZnAmYmo5WPph3+BNLO5PkGMiV@mail.gmail.com
Whole thread Raw
Responses Re: Configure default for sorting of null-values?  (Rob Gansevles <rgansevles@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Table update problem works on MySQL but not Postgres
Next
From: Adarsh Sharma
Date:
Subject: Problem in getting Output