Re: 7.2.1: coalesce double-calls function?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 7.2.1: coalesce double-calls function?
Дата
Msg-id 13346.1043422649@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 7.2.1: coalesce double-calls function?  ("SZŰCS Gábor" <surrano@mailbox.hu>)
Ответы Re: 7.2.1: coalesce double-calls function?
Список pgsql-general
"=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" <surrano@mailbox.hu> writes:
> CONCLUSION: I think both the optimizer, both the side effects would be
> happier if all of COALESCE's expressions were only calculated once.

Yup, and NULLIF too.  Want to submit a patch?  Look for CaseExpr in the
sources, copy/paste/modify.

            regards, tom lane

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