Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table my_table(someDate date)

CREATE TABLE


select someDate sd 
from my_table
order by case when 1=1 then sd end desc

ERROR:  column "sd" does not exist
LINE 3: order by case when 1=1 then sd end desc
                                    ^


with t as
(
  select someDate sd 
  from my_table
)
select sd
from t
order by case when 1=1 then sd end desc


sd



SELECT 0