Evaluation of if conditions

Поиск
Список
Период
Сортировка
От Daniel CAUNE
Тема Evaluation of if conditions
Дата
Msg-id 001601c6d204$5d2cd840$0b00a8c0@tedy
обсуждение
Ответы Re: Evaluation of if conditions
Re: Evaluation of if conditions
Re: Evaluation of if conditions
Список pgsql-sql
Hi,

How does the IF statement evaluate conditions?  Does it evaluate conditions
following their declaration order from left to right?  In case of
or-conditions, does the IF statement stop evaluating conditions whenever a
first or-condition is true?

The following snippet seems to be invalid, which let me think that PL/PGSQL
evaluates all the conditions:
 IF (TG_OP = 'INSERT') OR    (OLD.bar = ...) THEN   statement END IF;

Should be rewritten as (for example):
 IF (TG_OP = 'INSERT') THEN   statement ELSIF (OLD.bar = ...) THEN   statement END IF;


Regards,

--
Daniel



В списке pgsql-sql по дате отправления: