How to use an ALIAS in a PostgreSQL ORDER BY clause?
You can always ORDER BY this way: select title, ( stock_one + stock_two ) as global_stock from product order by 2, 1 or wrap it in another SELECT: SELECT * from ( select title, ( stock_one + stock_two ) as global_stock from product ) x order by (case when global_stock = 0 then 1 else … Read more