Re: Sorting by NULL values

From: Dan Langille <dan(at)langille(dot)org>
To: Ian Burrell <ib(at)onsitetech(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Sorting by NULL values
Date: 2003-03-04 20:07:29
Message-ID: 20030304150627.H38754@xeon.unixathome.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, 4 Mar 2003, Ian Burrell wrote:

> Is there any standard on how sorting NULLs work? Is there a way to
> change Postgres's behavior? Is there a way to replace the NULLs with
> empty strings?

I think what you want may be either COALESCE or ISNULL/IFNULL or perhaps a
CASE statement.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Greg Stark 2003-03-04 20:10:23 Re: Forcing query to use an index
Previous Message Tomasz Myrta 2003-03-04 20:01:31 Re: Sorting by NULL values