=?iso-2022-jp?B?GyRCQ2ZAbiEhQD81LhsoQg==?= <nakag...@ivp.co.jp> writes: > I'm trying to use like 'xx%' search on Text[] column. > I thought it uses index scan. But actually it uses seq scan.
> Why? Those ANY expressions are not indexable. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql