Re: [SQL] ORDER BY TIMESTAMP_column ASC, NULL first

[Tomasz Myrta]

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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match