On Sat, 19 Feb 2005 12:01:07 -0600, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
On Sat, Feb 19, 2005 at 18:04:32 +0100,
charlie clark <[EMAIL PROTECTED]> wrote:
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
On Sat, Feb 19, 2005 at 18:04:32 +0100,
charlie clark <[EMAIL PROTECTED]> wrote:
> 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 qu
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
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 w
