CASE...WHEN... END

From: Giovanni Giuffrida <giovanni(at)cs(dot)ucla(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: CASE...WHEN... END
Date: 1998-10-07 19:59:17
Message-ID: 361BC814.FA29D288@cs.ucla.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Gemeinschaft Studienarbeit Datenbanken 1998-10-07 22:05:05 Updates/Deletes on class*
Previous Message Florian M Unterkircher 1998-10-07 19:52:39 unsubscribe