News for hackers. Stuff that matters.
Re:Building a MongoDB Clone in Postgres by rarrrrrr on Monday June 04, 2012 @02:30PM (#4065191)
I haven't tried it, but I think you would be able to use a PostgreSQL functional index (i.e. indexing the result of a function call to extract a particular bit of data from the JSON.)

http://www.postgresql.org/docs/9.1/interactive/indexes-expre...

Re:Building a MongoDB Clone in Postgres by rosser on Monday June 04, 2012 @02:34PM (#4065212)
I was just coming here to say exactly this. You could also use a partial index (that is, an index with a WHERE clause; so, "WHERE json_field LIKE '%foo.bar = baz%'" or whatever).
Re:Building a MongoDB Clone in Postgres by jerrysievert on Monday June 04, 2012 @02:35PM (#4065216)
you can, but in order to build a partial index, the function needs to be immutable. not exactly ideal in this case.
Re:Building a MongoDB Clone in Postgres by rosser on Monday June 04, 2012 @02:40PM (#4065236)
Immutability is perfectly appropriate for that use-case, though. Creating an index via a function that may return different outputs when provided the same input is always going to lose.