Обсуждение: CASE...WHEN... END

Поиск
Список
Период
Сортировка

CASE...WHEN... END

От
Giovanni Giuffrida
Дата:
  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