With JSONB here, JSONPath starts to become very interesting... http://goessner.net/articles/JsonPath/ http://goessner.net/articles/JsonPath/ http://blog.redfi

With JSONB here, JSONPath starts to become very interesting... http://goessner.net/articles/JsonPath/ http://goessner.net/articles/JsonPath/ http://blog.redfin.com/devblog/2012/03/json_in_postgres.html http://blog.redfin.com/devblog/2012/03/json_in_postgres.html That article was written before JSON/JSONB showed up, but the idea remains the same. I didn't have plv8 installed, so I did some plumbing code in plpython. plv8 would be more suitable though. https://github.com/jvinet/pg-jsonpath https://github.com/jvinet/pg-jsonpath