On 30/6/21 18:55, Laurenz Albe wrote:
On Wed, 2021-06-30 at 14:21 +0300, Andrey Lepikhov wrote:
I think, here we could ask more general question: do we want to remove a
'IS NOT NULL' clause from the clause list if the rest of the list
implicitly implies it?
Generally I have the impression that we are not too keen on spending
planning time on optimizing cases that can be trivially improved by rewriting
the query.
Thank you, It's strong argument.
Such feature would look better as a part of an enterprise edition.
--
regards,
Andrey Lepikhov
Postgres Professional