| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | Merlin Moncure <mmoncure(at)gmail(dot)com>, Oleg Bartunov <obartunov(at)gmail(dot)com>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: jsonb and nested hstore |
| Date: | 2014-02-05 19:35:44 |
| Message-ID: | 52F29290.7000601@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2014-02-05 19:46:53 | Re: narwhal and PGDLLIMPORT |
| Previous Message | Alvaro Herrera | 2014-02-05 19:26:19 | Re: Add CREATE support to event triggers |