The following bug has been logged online:
Bug reference: 4917
Logged by: MIchael Blake
Email address: michael.blake@webdynamic.com.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
