Hacker News new | past | comments | ask | show | jobs | submit login

Yep, you can index any expression on a single row in postgres. The downside is that the optimizer will only use the index if the query contains that exact expression, while it's usually smarter with column indexes.

The only limit that I've run into in comparison with NoSQL databases is that you cannot index fields inside arrays within the column (json -> arrayIndex -> field), you need to normalize the array to a different table.




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

Search: