Re: how to query against nested hstore data type - Mailing list pgsql-general

From Huang, Suya
Subject Re: how to query against nested hstore data type
Date
Msg-id D83E55F5F4D99B4A9B4C4E259E6227CD014F7904@AUX1EXC02.apac.experian.local
Whole thread Raw
In response to Re: how to query against nested hstore data type  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
Responses Re: how to query against nested hstore data type  ("Huang, Suya" <Suya.Huang@au.experian.com>)
List pgsql-general
-----Original Message-----
From: Peter Geoghegan [mailto:peter.geoghegan86@gmail.com] 
Sent: Monday, August 25, 2014 12:14 PM
To: Huang, Suya
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] how to query against nested hstore data type

On Sun, Aug 24, 2014 at 7:05 PM, Huang, Suya <Suya.Huang@au.experian.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
valuepair at root level, but is not sure how to go deeper...
 



pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: how to query against nested hstore data type
Next
From: "Huang, Suya"
Date:
Subject: Re: how to query against nested hstore data type