yes, I could not figure out why my GIN index was not used, this is what
i meant.
On 09/04/12 18:16, Tom Lane wrote:
> Robert Haas<robertmhaas@gmail.com> writes:
>> We do have this:
>> <para>
>> The operators<literal>&&</>,<literal>@></> and
>> <literal><@</> are equivalent to<productname>PostgreSQL</>'s built-in
>> operators of the same names, except that they work only on integer arrays
>> that do not contain nulls, while the built-in operators work for any array
>> type. This restriction makes them faster than the built-in operators
>> in many cases.
>> </para>
>> But maybe some more explicit warning is needed. Not sure exactly what.
> I think the gripe is basically that, while these operators might be
> equivalent to the built-in ones as far as results go, they are not
> equivalent in terms of their ability to match to indexes. But not
> sure how we turn that observation into useful documentation.
>
> regards, tom lane
--
Kasper Sandberg
Sandberg Enterprises
+45 51944242
http://www.sandbergenterprises.dk