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>) |
| Ответы |
Re: Convert coalesce to or/and
|
| Список | 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 по дате отправления: