views:

29

answers:

1

I'm wondering if I can do something like

CREATE INDEX firstelement ON mytable (myarray[1]);

this particular syntax creates a syntax error.

+2  A: 

Try this one, with extra parentesis:

CREATE INDEX firstelement ON mytable ((myarray[1]));
Frank Heikens