On Thu, Sep 23, 2021 at 10:33 PM Tomas Vondra <tomas.von...@enterprisedb.com> wrote: > > 2) create_publication.sgml says: > > A <literal>NULL</literal> value causes the expression to evaluate > to false; avoid using columns without not-null constraints in the > <literal>WHERE</literal> clause. > > That's not quite correct, I think - doesn't the expression evaluate to > NULL (which is not TRUE, so it counts as mismatch)? > > I suspect this whole paragraph (talking about NULL in old/new rows) > might be a bit too detailed / low-level for user docs. >
Updated docs in v44 [1] ------ [1] https://www.postgresql.org/message-id/CAHut%2BPtjxzedJPbSZyb9pd72%2BUrGEj6HagQQbCdO0YJvr7OyJg%40mail.gmail.com Kind Regards, Peter Smith. Fujitsu Australia