Evaluate arguments of COALESCE and NULLIF only once.

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Evaluate arguments of COALESCE and NULLIF only once.
Дата
Msg-id Pine.LNX.4.33.0302112136090.21758-200000@leary.csoft.net
обсуждение исходный текст
Ответы Re: Evaluate arguments of COALESCE and NULLIF only once.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Currently the parser transforms COALESCE and NULLIF statements to an
equivalent CASE statement.  The downside to this is that arguments must be
evaluated for both the WHEN and THEN sections of the CASE statement.
This is a problem if the arguments are expensive or volatile functions.
Consider evaluating

SELECT COALESCE(ten_millionth_digit_of_pi(),1);

OR

SELECT COALESCE(randomlynull(), 1);

The first statement will take twice as long.  The second statement will
sometimes return NULL because the first evaluation returns a non null
value, but the second evaluation returns null.

The following patch makes COALESCE and NULLIF first class expressions with
all the associated machinery.

Kris Jurka

Вложения

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

Предыдущее
От: greg@turnstep.com
Дата:
Сообщение: Re: FAQ addition: deleteing all but one unique row
Следующее
От: "Matthew T. O'Connor"
Дата:
Сообщение: pg_avd