Steve Crawford <scrawford(at)pinpointresearch(dot)com> writes:> How can I create an index on an array element?
You need 7.4 and an extra layer of parentheses:
create index foodex on foo ((textarray[3]));
regards, tom lane