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

From charlie clark
Subject How do I change sort order behavious with nulls
Date
Msg-id opsmge1uvryt02yl@mail.isis.de
Whole thread Raw
Responses Re: How do I change sort order behavious with nulls  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: How do I change sort order behavious with nulls  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Dear list,

is there a simple way to change the way ORDER BY works on columns with
NULLs? I can understand the need for default behaviour but there must be
cases when this is undesirable. I have such a query with the NULLs arising
as the result of an OUTER JOIN and I would like to ORDER BY DESC with
NULLs treated as <= 0. I've already tried a few things but nothing's
working so far.

Thanx for any pointers.

Charlie

--
Charlie Clark

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Group By and wildcards...
Next
From: "Daniel Verite"
Date:
Subject: Re: I'm newbie