How to conditionally extract different data in postgres?

Question

PostgreSQL

Good afternoon,
There is a table:
tarifs
--------------
id
price
percent (default NULL)
I want to pull out if percent is not NULL :
( (tarifs.price * tarifs.percent ) / 100 )
Otherwise, you just need to pull out price .
How can this be done conditionally in postgres ?

Answer 1

As in any other DBMS

SELECT
    CASE
        WHEN percent IS NOT NULL THEN price * percent / 100
        ELSE price
    END as price
FROM tarifs