3 ms·
It's just a JSON syntax validator. You can't index on part of the json, postgres treats it as a string. You can apply full text search on it, but that doesn't
by jvehent 14y ago
It's just a JSON syntax validator. You can't index on part of the json, postgres treats it as a string.
You can apply full text search on it, but that doesn't tell you if you're matching on a key or a value.
- ismarc 14y agoIn postgres, you can index on a stored procedure, so you can use a simple stored procedure written in JavaScript to look up by key and return values, etc. Example available at http://people.planetpostgresql.org/andrew/index.php?/archives/249-Using-PLV8-to-index-JSON.html http://people.planetpostgresql.org/andrew/index.php?/archive...