Re: how to query against nested hstore data type

-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Sent: Wednesday, August 27, 2014 12:42 PM
To: Huang, Suya; pgsql-general@postgresql.org
Subject: Re: [GENERAL] how to query against nested hstore data type

On 08/26/2014 06:50 PM, Huang, Suya wrote:
>
>
> -----Original Message-----
> From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
> Sent: Tuesday, August 26, 2014 11:58 PM
> To: Huang, Suya; pgsql-general@postgresql.org

>

<Quote>
I've figured out, have to apply a separate patch to query out of nested hstore.
http://www.sigaev.ru/git/gitweb.cgi?p=hstore.git;a=summary
<Quote>

Before you go to far with this I would read this blog:

http://obartunov.livejournal.com/177670.html

Basically the patch is a dead end.

--
Adrian Klaver
adrian.klaver@aklaver.com

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

Hmm, may worth spending sometime on jsonb. Thanks Adrian for the notice.

Thanks,
Suya