Randolf Richardson <[EMAIL PROTECTED]> 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]));
> Sorry, but this isn't obvious to me as arrays in a database are a new
> concept for
Steve Crawford <[EMAIL PROTECTED]> 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
---(end of broadcast)---
How can I create an index on an array element? I seem to recall having
done this in the past but I don't recall how.
steve=# \d foo
Table "public.foo"
Column | Type | Modifiers
---++---
textarray | text[] |
steve=# create index foodex on foo (textarray[3]);
