On Sat, Dec 25, 2021, at 1:20 AM, Amit Kapila wrote: > On Fri, Dec 24, 2021 at 11:04 AM Peter Smith <smithpb2...@gmail.com> 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.
-- Euler Taveira EDB https://www.enterprisedb.com/