Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

you should be able to index on an expression without adding the column.

eg

  create index on blah((jsoncolumn->>'new_thing'));
although I haven't tried it myself yet, I've been meaning to play with that feature.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: