An to be more precise what I exactly want to do :
select case when 'now' between t.begin and t.end then t.login else 'None' end as log
from my_table t
order by lower(log);
Try:
select log from (select case when 'now' between t.begin and t.end then t.login else 'None' end as log from my_table t) as ss order by lower(log);
HTH,
Joe
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
