Fabien COELHO <[EMAIL PROTECTED]> writes: > The standard "EVERY" is fine for postgres, the issue is only with > ANY/SOME. > Do you think that bool_and should be proposed anyway for homogeneity > with bool_or?
I think EVERY is actively misleading, because it does *not* imply that every input is TRUE. The spec says these aggregates should ignore nulls, and so a true result only implies that there were no FALSE inputs. OTOH one could argue that the ignore-nulls behavior makes this not a true analog of AND, either ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings