Re: Sorting by NULL values - Mailing list pgsql-sql

From Dan Langille
Subject Re: Sorting by NULL values
Date
Msg-id 20030304150627.H38754@xeon.unixathome.org
Whole thread Raw
In response to Sorting by NULL values  (Ian Burrell <ib@onsitetech.com>)
List 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.


pgsql-sql by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: Forcing query to use an index
Next
From: Greg Stark
Date:
Subject: Re: Forcing query to use an index