-----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxxxx] Sent: Wednesday, August 27, 2014 12:42 PM To: Huang, Suya; pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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@xxxxxxxxxxx] > Sent: Tuesday, August 26, 2014 11:58 PM > To: Huang, Suya; pgsql-general@xxxxxxxxxxxxxx > <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@xxxxxxxxxxx ================================================================================================================ Hmm, may worth spending sometime on jsonb. Thanks Adrian for the notice. Thanks, Suya -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general