Обсуждение: IF statement in Select

Поиск

Список

Период

Сортировка

IF statement in Select

От

Renato Cramer

Дата:

05 апреля 2006 г., 13:59:56

Hello all,

Is the use of IF statement restrict to Functions and Store Procedures?

I'm trying to use an IF within Select...

Example:
create view v1 as
select c1,c2,if c3 = 52 then 0else 1endif as base_irrf_13from t1;

Thanks in advance,

Renato Cramer.

Re: IF statement in Select

От

"William Leite Araújo"

Дата:

05 апреля 2006 г., 14:04:38

You can use "Case"

SELECT c1, c2, CASE WHEN c3 = 52 THEN 0 ELSE 1 END AS base_irrf_13 FROM t1;

On 4/5/06, Renato Cramer < renato@domsis.com.br> wrote:

Hello all,

Is the use of IF statement restrict to Functions and Store Procedures?

I'm trying to use an IF within Select...

Example:
create view v1 as
select c1,
c2,
if c3 = 52 then 0
else 1
endif as base_irrf_13
from t1;

Thanks in advance,

Renato Cramer.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

--
William Leite Araújo

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: IF statement in Select

IF statement in Select

Re: IF statement in Select