Re: Index on array element

From: Randolf Richardson <rr(at)8x(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Index on array element
Date: 2003-11-25 17:59:01
Message-ID: Xns943E637F068A7rr8xca@200.46.204.72
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)8x(dot)ca
Vancouver, British Columbia, Canada

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vernon Smith 2003-11-25 18:01:12 (No Subject)
Previous Message Tom Lane 2003-11-25 16:56:51 Re: get_typdefault: failed to ...