Re: jsonb and nested hstore

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Peter Geoghegan <pg(at)heroku(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Christophe Pettus <xof(at)thebuild(dot)com>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: jsonb and nested hstore
Date: 2014-03-05 19:05:28
Message-ID: 20140305190528.GB15259@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Mar 5, 2014 at 10:59:37AM -0800, Peter Geoghegan wrote:
> On Wed, Mar 5, 2014 at 8:30 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> >> Just out of curiosity, exactly what features are missing from jsonb
> >> today that are available with hstore? How long would it take to
> >> copy-and-paste all that code, if someone were to decide to do the
> >> work instead of argue about it?
> >
> > I believe the main thing is the opclasses.
>
> Yes, that's right. A large volume of code currently proposed for
> hstore2 is much less valuable than those operators sufficient to
> implement the hstore2 opclasses. If you assume that hstore will become
> a legacy extension that we won't add anything to (including everything
> proposed in any patch posted to this thread), and jsonb will go in
> core (which is of course more or less just hstore2 with a few json
> extras), the amount of code redundantly shared between core and an
> unchanged hstore turns out to not be that bad. I hope to have a
> precise answer to just how bad soon.

Can you clarify what hstore2 is? It that the name of a type? Is that
hierarchical hstore with the same hstore name?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2014-03-05 19:06:27 Re: GSoC propostal - "CREATE SCHEMA ... LIKE ..."
Previous Message Robert Haas 2014-03-05 19:04:11 Re: Changeset Extraction v7.9.1