We have a bag of utils internally to paper over the missing JSONB functions. This was definitely a headache at first. This is mostly fixed in 9.5: http://blog.

We have a bag of utils internally to paper over the missing JSONB functions. This was definitely a headache at first. This is mostly fixed in 9.5: http://blog.2ndquadrant.com/jsonb-and-postgresql-9-5-with-even-more-powerful-tools/ http://blog.2ndquadrant.com/jsonb-and-postgresql-9-5-with-ev...