BUG #4917: NULLs Last as a Global Option

From: "MIchael Blake" <michael(dot)blake(at)webdynamic(dot)com(dot)au>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4917: NULLs Last as a Global Option
Date: 2009-07-12 23:48:30
Message-ID: 200907122348.n6CNmU5j003985@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4917
Logged by: MIchael Blake
Email address: michael(dot)blake(at)webdynamic(dot)com(dot)au
PostgreSQL version: 8.3
Operating system: Linux [Ubuntu 9.04]
Description: NULLs Last as a Global Option
Details:

Could an option be added to postgresql.conf for default ordering of NULL
values for different sort orders? That is, I'd like to be able to force
NULLs to be last for date types and number types for descending, but first
for ascending - the trick is I'd like this to be the default globally.

For example:

null_ordering_asc = first
null_ordering_desc = last

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message goldenhawking 2009-07-13 04:54:20 Re: BUG #4785: Installation fails
Previous Message Pavel Stehule 2009-07-12 20:25:44 fix: plpgsql: return query and dropped columns problem