Re: Sorting by NULL values

Ian Burrell wrote:
> I am doing a query where I need to sort by a column that may be NULL 
> because it is coming from an OUTER JOIN.  I noticed a difference between
> PostgreSQL and other databases about where NULLs show up.  It seems that 
> with Postgres, NULLs are sorted after other values.  Other databases 
> sort them before.
> 
> 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?
order by field is null asc/desc, field asc/desc

Regards,
Tomasz Myrta