Received: from giovanni.cs.ucla.edu (root@Giovanni.CS.UCLA.EDU [131.179.176.108]) by hub.org (8.8.8/8.8.8) with ESMTP id QAA29420 for ; Wed, 7 Oct 1998 16:05:48 -0400 (EDT) (envelope-from giovanni@cs.ucla.edu) Received: from cs.ucla.edu (giovanni@localhost [127.0.0.1]) by giovanni.cs.ucla.edu (8.8.8/8.8.8) with ESMTP id MAA01323 for ; Wed, 7 Oct 1998 12:59:17 -0700 Sender: giovanni@giovanni.cs.ucla.edu Message-ID: <361BC814.FA29D288@cs.ucla.edu> Date: Wed, 07 Oct 1998 12:59:17 -0700 From: Giovanni Giuffrida Organization: UCLA X-Mailer: Mozilla 4.05 [en] (X11; I; Linux 2.0.35 i686) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: CASE...WHEN... END Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 THEN WHEN THEN : ELSE END Thank you, Giovanni