Re: jsonb and nested hstore

On 02/05/2014 02:03 PM, Josh Berkus wrote:

> Frankly, if it were entirely up to me HSTORE2 would be part of core and
> its only interface would be JSONB.  But it's not.  So this is a compromise.
>

You could only do that by inventing a new type. But hstore2 isn't a new 
type, it's meant to be the existing hstore type with new capabilities.

Incidentally, some work is being done by one of my colleagues on an 
extension of gin/gist operators for indexing jsonb similarly to hstore2. 
Now that will possibly be something we can bring into 9.4, although 
we'll have to check how we go about pg_upgrade for that case.

cheers

andrew