"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes: > On Wed, May 25, 2016 at 7:42 PM, David G. Johnston < > david.g.johnston@xxxxxxxxx> wrote: >> â??What's the query with the revised parentheses? > â??Never mind...your right I doubt that it should matter. The parentheses in the original *definitely* matter, because by default AND binds more tightly than OR. The larger number of rows in the second query are perfectly plausible given the parenthesis-omission. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general