Re: how to query against nested hstore data type

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Huang, Suya
Sent: Monday, August 25, 2014 12:18 PM
To: Peter Geoghegan
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] how to query against nested hstore data type

-----Original Message-----
From: Peter Geoghegan [mailto:peter(dot)geoghegan86(at)gmail(dot)com]
Sent: Monday, August 25, 2014 12:14 PM
To: Huang, Suya
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] how to query against nested hstore data type

On Sun, Aug 24, 2014 at 7:05 PM, Huang, Suya <Suya(dot)Huang(at)au(dot)experian(dot)com> wrote:
> It’s my test DB, the version is PostgreSQL 9.4beta2. I’m testing with
> nested hstore feature.

Really? Nested hstore only made it into that version as jsonb, which you're clearly not using here.

--
Regards,
Peter Geoghegan

============================================================================================

I can insert and query rows with nested hstore structure as you can see in the output. And is able to query the key value pair at root level, but is not sure how to go deeper...

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

==============================================================================================

From this thread http://postgresql.1045698.n5.nabble.com/hstore-jsonb-td5798654.html , it says the development on nested hstore has frozen.
Also, I've found http://www.sigaev.ru/git/gitweb.cgi?p=hstore.git;a=blob;f=README;h=c8af7f50cfd58ed3b1cd18f9ec34f44ada59c34e;hb=d7a5fe1d301a520c9e1f5570c4a345915865f21b as a separate patch to be applied on 9.4 to use nested hstore.

Does it mean we should turn to using jsonb instead of nested hstore as it seems it's not going to be on the main development branch?