News for hackers. Stuff that matters.
Re:Hstore development for 9.4 release by gibybo on Thursday November 07, 2013 @10:37AM (#6689903)
Can I index fields within a JSON document in PostreSQL? Can I query them?

I.e. can I do something like SELECT json_field FROM data WHERE json_field.age > 15 ?

Re:Hstore development for 9.4 release by rpedela on Thursday November 07, 2013 @10:48AM (#6689976)
That query would be this:

SELECT json_field FROM data WHERE json_field->'age' > 15

Part of the performance increase for hstore is improvements for GIN indexes, and according to the author can be applied to json. So yes you can use indexes on your hstore or json documents.

Re:Hstore development for 9.4 release by andreypopp on Thursday November 07, 2013 @10:38AM (#6689914)
Yes, this is what index scan performance metrics is about — PostgreSQL outperforms MongoDB here.
Re:Hstore development for 9.4 release by itodd on Thursday November 07, 2013 @10:40AM (#6689923)
Re:Hstore development for 9.4 release by jeffasinger on Thursday November 07, 2013 @12:18PM (#6690660)
Yes, for a project I'm working on, I had a JSON array of objects that each had a key called name.

I have fast indexed queries that return any rows that have an object with a given name in it, and for full text search on that name along with a few other things.

Re:Hstore development for 9.4 release by chrisfarms on Thursday November 07, 2013 @10:40AM (#6689926)