Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Index on array element
Date
Msg-id 25241.1069740056@sss.pgh.pa.us
Whole thread Raw
In response to Index on array element  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL certifications?
Next
From: Shridhar Daithankar
Date:
Subject: Re: The new autovacuum tool