Re: Index on array element

Steve Crawford <scrawford@pinpointresearch.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