Re: Problem of Null Ordering

Harry Yau wrote:

When I query this table and Order by IF1, the row that have the value of
NULL will come after the row that have a number value. I am wondering is
there anything I can do to make the row with Null value come before the
row with a number value.

All you need to do is order your results by IF1. Use:

select IF1 from TABLE_NAME order by IF1 desc;

Jc

PS Don't crosspost to other postgres groups. It's very rude. Pick the
group that best first your particular need and post to only that group.