Received: from virtualsw.es (virtualsw.es [195.76.91.1]) by hub.org (8.9.2/8.9.1) with ESMTP id FAA66723 for ; Mon, 29 Mar 1999 05:50:15 -0500 (EST) (envelope-from enoeda@virtualsw.es) Received: from duka (enoeda.vrtsw [192.168.33.23]) by virtualsw.es (8.8.5/8.8.4) with ESMTP id MAA05353 for ; Mon, 29 Mar 1999 12:50:15 +0200 Message-ID: <199903291249190210.00CEB3B9@mail.virtualsw.es> X-Mailer: Calypso Version 3.00.00.13 (3) Date: Mon, 29 Mar 1999 12:49:19 +0200 From: "Eduardo Noeda" To: pgsql-sql@postgreSQL.org Subject: IIF.. Mime-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id FAA66742 Hi! I'm new in the list (and in PostgreSQL too). I'd like to know if it's posible to perform a function like SQL Server's "iif" in a SELECT query. Some like: SELECT iif (Number=1, "First", "Other") AS Description FROM Table; I don't know if I've explained properly... -- Eduardo Noeda -- Virtual Software enoeda@virtualsw.es