Re: How do I change sort order behavious with nulls - Mailing list pgsql-general

charlie clark <charlie@begeistert.org> writes:
> is there a simple way to change the way ORDER BY works on columns with
> NULLs?

No, but you can do something like

    ORDER BY foo IS NOT NULL, foo DESC

to make the nulls come first.

            regards, tom lane