IIF..

From: "Eduardo Noeda" <enoeda(at)virtualsw(dot)es>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: IIF..
Date: 1999-03-29 10:49:19
Message-ID: 199903291249190210.00CEB3B9@mail.virtualsw.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)virtualsw(dot)es

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rick Dearman 1999-03-29 10:51:37 Returning an integer from a date
Previous Message Herouth Maoz 1999-03-29 10:34:14 Re: [GENERAL] Determining if "in a text set"