I'm wondering if I can do something like
CREATE INDEX firstelement ON mytable (myarray[1]);
this particular syntax creates a syntax error.
I'm wondering if I can do something like
CREATE INDEX firstelement ON mytable (myarray[1]);
this particular syntax creates a syntax error.
Try this one, with extra parentesis:
CREATE INDEX firstelement ON mytable ((myarray[1]));