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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers