Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.9.2/8.9.1) with ESMTP id SAA51204 for ; Mon, 29 Mar 1999 18:29:44 -0500 (EST) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id NAA20589; Mon, 29 Mar 1999 13:20:49 -0600 (CST) Received: from unknown(144.210.12.10) by gauntlet.bjke.com via smap (4.1) id xma019425; Mon, 29 Mar 99 13:19:49 -0600 Received: by cpsmail with Internet Mail Service (5.5.2448.0) id ; Mon, 29 Mar 1999 13:20:16 -0600 Message-ID: From: "Jackson, DeJuan" To: Eduardo Noeda , pgsql-sql@postgreSQL.org Subject: RE: [SQL] IIF.. Date: Mon, 29 Mar 1999 13:20:15 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain; charset="iso-8859-1" It would be: SELECT (CASE Number WHEN 1 THEN 'First' ELSE 'Other' END) AS Description FROM Table -DEJ > -----Original Message----- > 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