By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
create table mytable (
my_number int
);
insert into mytable values
(1200),
(0),
(Null);
SELECT
CASE WHEN COALESCE(my_number,0) = 0 THEN 0 ELSE CAST(my_number AS decimal(10,2)) END as "My number"
FROM mytable
CREATE TABLE
INSERT 0 3
| My number |
|---|
| 1200.00 |
| 0 |
| 0 |
SELECT 3
select my_number,
case
when my_number is null or my_number = 0 then '0'
else to_char(my_number, 'FM99999990.00')
end as my_new_number
from mytable
| my_number | my_new_number |
|---|---|
| 1200 | 1200.00 |
| 0 | 0 |
| null | 0 |
SELECT 3