3 ms·

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

• einhverfr 14y ago
  In addition, I don't know what you'd index if it wasn't through a function. Indexing JSON data as JSON? Why?
  • masklinn 14y ago
    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.
    • einhverfr 14y ago
      Hence using a function to extract that and then indexing the function's output. That can be done in PostgreSQL right now.