To avoid creation of custom GiST-index you can use hstore, which supports GiST and GIN indexes. I propose you to add hstore column to the table and write trigger function which will generate hstore from array on insert or update. Or you can use hstore column instead of array. Please, see http://www.postgresql.org/docs/9.0/static/hstore.html
Are there any technique to index that query for like search on Text[] Columns?
Thanks.
Nakagawa Maskai
-------------------------------------------------- From: "Tom Lane" <tgl@sss.pgh.pa.us> Sent: Saturday, January 15, 2011 2:56 AM To: "中川 誠貴" <nakagawa@ivp.co.jp> Cc: <pgsql-sql@postgresql.org> Subject: Re: [SQL] why does seq scan instead of index scan