James Coleman <jtc...@gmail.com> writes: > On Sun, Apr 26, 2020 at 12:13 PM Justin Pryzby <pry...@telsasoft.com> wrote: >> I think my text is correct. This would *also* be correct: >> | If any <literal>CHECK</literal> constraint on the table being >> | attached is marked <literal>NO INHERIT</literal>, the command will >> fail; >> But not the hybrid: "If any OF THE .. is .."
> "any of the...are" sounds more natural to my ears, Yeah, I think the same. If you want to argue grammar, I'd point out that the "any" could refer to several of the constraints, making it correct to use the plural verb. The alternative that Justin mentions could be written as "If any one constraint is ...", which is correct in that form; but the plural way seems less stilted. regards, tom lane