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