Re: Index on array element - Mailing list pgsql-general

>> 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]));

        Sorry, but this isn't obvious to me as arrays in a database are a new
concept for me -- why are the extra layer of parenthesis needed?

--
Randolf Richardson - rr@8x.ca
Vancouver, British Columbia, Canada

Please do not eMail me directly when responding
to my postings in the newsgroups.