开发者

Can you index elements of an array in Postgres?

开发者 https://www.devze.com 2023-01-13 19:56 出处:网络
I\'m wondering if I can do something like CREATE INDEX firstelement ON mytable (myarray[1]); this part开发者_如何转开发icular syntax creates a syntax error.Try this one, with extra parentesis:

I'm wondering if I can do something like

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

this part开发者_如何转开发icular syntax creates a syntax error.


Try this one, with extra parentesis:

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

精彩评论

暂无评论...
验证码 换一张
取 消