Robert Haas <robertmh...@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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
