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

I think you can index JSON using a function based index, which will probably cover a lot of use-cases.


In addition, I don't know what you'd index if it wasn't through a function. Indexing JSON data as JSON? Why?


Not indexing JSON data as JSON, indexing a record based (in part) on the content of its JSON field(s) selected via e.g. an xpath-like query.


Hence using a function to extract that and then indexing the function's output. That can be done in PostgreSQL right now.




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

Search: