Postgres Pro
Downloads
Home   >   mailing lists

Re: GIN index isn’t working with intarray - Mailing list pgsql-bugs

From Tom Lane
Subject Re: GIN index isn’t working with intarray
Date
Msg-id 14840.1450739736@sss.pgh.pa.us
Whole thread Raw
In response to GIN index isn’t working with intarray  ("Maeldron T." <maeldron@gmail.com>)
List pgsql-bugs
Tree view 
"Maeldron T." <maeldron@gmail.com> writes:
> As soon as intarray is created, the &&, @>, <@ operators
> stop using the GIN index.

intarray defines its own versions of those operators, which have nothing
to do with the standard GIN index.  You can create an index using
intarray's custom GIN opclass, instead.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #9923: "reassign owned" does not change permissions grantor
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #13666: REASSIGN OWNED BY doesn't affect the relation underlying composite type