Hello,
I wonder if the CASE (available in SQL-92) statement is available in
Postgres, or if there is any similar way of solving the problem.
The syntax of case is:
CASE WHEN <cond1> THEN <value1>
WHEN <cond2> THEN <value2>
:
ELSE <else-value>
END
Thank you,
Giovanni