Re: Convert coalesce to or/and

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Convert coalesce to or/and
Дата
Msg-id 4125586.1767307866@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Convert coalesce to or/and  (Nicolas Adenis-Lamarre <nicolas.adenis.lamarre@gmail.com>)
Список pgsql-hackers
Nicolas Adenis-Lamarre <nicolas.adenis.lamarre@gmail.com> writes:
> would it be accepted to do a patch to replace coalesce by and/or,
> mainly to fix related estimations.

Almost certainly not.  It'd be very hard to do that while preserving
the expected semantics of COALESCE: no argument is to be evaluated
more than once, and people sometimes expect strict left-to-right
evaluation.  I've even seen it used as an intentional optimization
fence.

If you think you can improve the estimation around it, I'd suggest
tackling that directly.

            regards, tom lane



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