On Sat, Dec 25, 2021, at 1:20 AM, Amit Kapila wrote:
>
> So, IMO the PG docs wording for this part should be relaxed a bit.
>
> e.g.
> BEFORE:
> + A nullable column in the <literal>WHERE</literal> clause could cause the
> + expression to evaluate to false; avoid using columns without not-null
> + constraints in the <literal>WHERE</literal> clause.
> AFTER:
> + A nullable column in the <literal>WHERE</literal> clause could cause the
> + expression to evaluate to false. To avoid unexpected results, any possible
> + null values should be accounted for.
>
Your suggested wording sounds reasonable to me. Euler, others, any thoughts?
+1.