Postgres Pro
Downloads
Home   >   mailing lists

Re: gin index postgres 9.2 - Mailing list pgsql-general

From Tom Lane
Subject Re: gin index postgres 9.2
Date
Msg-id 32122.1464221359@sss.pgh.pa.us
Whole thread Raw
In response to Re: gin index postgres 9.2  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: gin index postgres 9.2  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view 
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Wed, May 25, 2016 at 7:42 PM, David G. Johnston <
> david.g.johnston@gmail.com> 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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: gin index postgres 9.2
Next
From: "David G. Johnston"
Date:
Subject: Re: gin index postgres 9.2