Create index on array element? - Mailing list pgsql-general

From Dave Bodenstab
Subject Create index on array element?
Date
Msg-id ekkr57$19ss$1@news.hub.org
Whole thread Raw
Responses Re: Create index on array element?  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
I guess one cannot create an index on an element of an array?

test=> create table test ( ordinal int[] );
CREATE TABLE
test=> create unique index x1 on test ( ordinal[1] );
ERROR:  syntax error at or near ")" at character 45
LINE 1: create unique index x1 on test ( ordinal[1] );
                                                     ^

Correct, or is my syntax wrong?


pgsql-general by date:

Previous
From: "Terry Yapt"
Date:
Subject: Re: [Windows] Pg_Restore on 8.1.5 and so on...
Next
From: "Ben Trewern"
Date:
Subject: Re: sudden drop in delete performance