I was in the audience!
It was a great session - you're a funny guy, explained the concepts well, and there was some really interesting real(or alternate :p) world use-cases for all this stuff.
Great stuff! Seems like the store_accessor works with the :json column type out of the box as well.
Throw in a JSON schema validator and we have full-blown validations for :hstore and :json!
Links to the talk, slides, sample code, and some follow up articles: http://monkeyandcrow.com/blog/postgres_railsconf2013/