Postgres Pro
Downloads
Home   >   mailing lists

Re: ORDER BY TIMESTAMP_column ASC, NULL first - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: ORDER BY TIMESTAMP_column ASC, NULL first
Date
Msg-id 402FD269.3030102@klaster.net
Whole thread Raw
In response to ORDER BY TIMESTAMP_column ASC, NULL first  (Fredrik Wendt <fredrik@csbnet.se>)
List pgsql-sql
Tree view 
Dnia 2004-02-12 11:06, Użytkownik Fredrik Wendt napisał:

> Hi!
> 
> I read posts telling me that NULL values are considered greater than
> non-null values. Fine. Is there a way to explicitly reverse this?

Sure, choose combination you need:

order by some_value is null asc/desc, some_value asc/desc

Regards,
Tomasz Myrta

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: returning multiple resultset?
Next
From: Stephan Szabo
Date:
Subject: Re: max timestamp