Re: [GENERAL] How do I change sort order behavious with nulls

[Tom Lane]

charlie clark <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq