CASE...WHEN... END - Mailing list pgsql-sql

  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