Postgres Pro
Downloads
Home   >   mailing lists

Re: Null ordering in queries can be changed by settings? - Mailing list pgsql-novice

From Thomas Kellerer
Subject Re: Null ordering in queries can be changed by settings?
Date
Msg-id kfl4ja$rfd$1@ger.gmane.org
Whole thread Raw
In response to Null ordering in queries can be changed by settings?  (Vincenzo Melandri <vmelandri@imolinfo.it>)
List pgsql-novice
Tree view 
Vincenzo Melandri, 15.02.2013 11:14:
> I stepped into the same problem as this guy from 2005.
> Is this problem changed in the last 8 years? :)
> Can it be changed from settings now?

You can use the SQL standard NULLS LAST/NULLS FIRST operator

select *
from foo
order by bar desc nulls last

select *
from foo
order by bar desc nulls first

pgsql-novice by date:

Previous
From: Vincenzo Melandri
Date:
Subject: Null ordering in queries can be changed by settings?
Next
From: Zach Seaman
Date:
Subject: Re: Insert output query to a column from a joined table in PostgreSQL 9.1