Want to make a condition based on Friday

Question

I use Flyway and Postgres what i want is :

if today is Friday:

INSERT INTO APP(ID, DAY, NAME) VALUES (1, NOW() + INTERVAL '3 DAY', 'foo');

else

INSERT INTO APP(ID, DAY, NAME) VALUES (1, NOW() + INTERVAL '1 DAY', 'foo');

Answer 1

Use case when expression

INSERT INTO APP(ID, DAY, NAME) 
    VALUES (1, case when to_char(NOW(), 'Dy')='Fri' then NOW() + INTERVAL '3 DAY' else NOW() + INTERVAL '1 DAY' end, 'foo')