Re: [GENERAL] gin index postgres 9.2

2016-05-25 Thread David G. Johnston
On Wed, May 25, 2016 at 8:09 PM, Tom Lane wrote: > "David G. Johnston" writes: > > On Wed, May 25, 2016 at 7:42 PM, David G. Johnston < > > david.g.johns...@gmail.com> wrote: > >> ​What's the query with the revised parentheses? > > > ​Never mind...your right I doubt that it should matter. > > Th

Re: [GENERAL] gin index postgres 9.2

2016-05-25 Thread Tom Lane
"David G. Johnston" writes: > On Wed, May 25, 2016 at 7:42 PM, David G. Johnston < > david.g.johns...@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

Re: [GENERAL] gin index postgres 9.2

2016-05-25 Thread David G. Johnston
On Wed, May 25, 2016 at 7:42 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, May 25, 2016 at 7:38 PM, Lucas Possamai > wrote: > >> yes.. I thought too. >> >> the results r still different >> > > ​What's the query with the revised parentheses? > > ​Never mind...your right I do

Re: [GENERAL] gin index postgres 9.2

2016-05-25 Thread David G. Johnston
On Wed, May 25, 2016 at 7:38 PM, Lucas Possamai wrote: > yes.. I thought too. > > the results r still different > ​What's the query with the revised parentheses? David J. ​

Re: [GENERAL] gin index postgres 9.2

2016-05-25 Thread Lucas Possamai
yes.. I thought too. the results r still different

Re: [GENERAL] gin index postgres 9.2

2016-05-25 Thread David G. Johnston
On Wed, May 25, 2016 at 6:34 PM, Lucas Possamai wrote: > I've got the following query: > > SELECT COUNT(DISTINCT j0_.id) AS sclr0FROM ja_customers j0_WHERE > ((LOWER(j0_.name_first) LIKE '%asd%' > OR LOWER(j0_.name_last) LIKE '%asd%' > OR LOWER(j0_.company) LIKE '%asd%' >

[GENERAL] gin index postgres 9.2

2016-05-25 Thread Lucas Possamai
I've got the following query: SELECT COUNT(DISTINCT j0_.id) AS sclr0FROM ja_customers j0_WHERE ((LOWER(j0_.name_first) LIKE '%asd%' OR LOWER(j0_.name_last) LIKE '%asd%' OR LOWER(j0_.company) LIKE '%asd%' OR LOWER(j0_.phone) LIKE '%asd%' OR LOWER(j0_.mobile) LIKE '%a