Re: Null ordering in queries can be changed by settings?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Null ordering in queries can be changed by settings?
Date: 2013-02-15 11:02:57
Message-ID: kfl4ja$rfd$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Zach Seaman 2013-02-15 16:23:33 Re: Insert output query to a column from a joined table in PostgreSQL 9.1
Previous Message Vincenzo Melandri 2013-02-15 10:14:35 Null ordering in queries can be changed by settings?