It's just a JSON syntax validator. You can't index on part of the json, postgres... | Hacker News

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

jvehent on Oct 18, 2012 | parent | context | favorite | on: Things I wish I knew about MongoDB a year 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 on Oct 18, 2012 [–]

In 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?/archive...

Consider applying for YC's Fall 2026 batch! Applications are open till July 27.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact