Re: jsonb and nested hstore - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: jsonb and nested hstore
Date
Msg-id CAHyXU0wHXxrgPntQo4QXFcdsx62_20=CfW91q+Bjeq1H1+9Dww@mail.gmail.com
Whole thread Raw
In response to Re: jsonb and nested hstore  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-hackers
On Thu, Mar 6, 2014 at 11:28 AM, Heikki Linnakangas
<hlinnakangas@vmware.com> wrote:
> So here my opinion on what we should do:
>
> 1. Forget about hstore2
> 2. Add GIN and GIST operator classes to jsonb, if they're ready for commit
> pretty darn soon. If not, punt them to next release.

For #2, would we maintain the hstore syntax for the searching
operators.  For example,

SELECT count(*) FROM jsonb_schema WHERE tabledata @> 'columns =>
{{column_name=>total_time}}';

Note the hstore-ish => in the searching operator.

merlin



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Securing "make check" (CVE-2014-0067)
Next
From: Oleg Bartunov
Date:
Subject: Re: jsonb and nested hstore