News for hackers. Stuff that matters.

A comment on Things I wish I knew about MongoDB a year ago. Parent comment

Re:Things I wish I knew about MongoDB a year ago by jvehent on Wednesday October 17, 2012 @08:57PM (#4667057)
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.

[ Parent | on HN ]
Re:Things I wish I knew about MongoDB a year ago by ismarc on Wednesday October 17, 2012 @09:44PM (#4667136)
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...
[ Parent | on HN ]