| From: | "Huang, Suya" <Suya(dot)Huang(at)au(dot)experian(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: how to query against nested hstore data type |
| Date: | 2014-08-28 00:13:41 |
| Message-ID: | D83E55F5F4D99B4A9B4C4E259E6227CD014F867D@AUX1EXC02.apac.experian.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
-----Original Message-----
From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
Sent: Wednesday, August 27, 2014 12:42 PM
To: Huang, Suya; pgsql-general(at)postgresql(dot)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(dot)klaver(at)aklaver(dot)com]
> Sent: Tuesday, August 26, 2014 11:58 PM
> To: Huang, Suya; pgsql-general(at)postgresql(dot)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(dot)klaver(at)aklaver(dot)com
================================================================================================================
Hmm, may worth spending sometime on jsonb. Thanks Adrian for the notice.
Thanks,
Suya
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerry Sievers | 2014-08-28 00:34:08 | Re: Atomicity of INSERT INTO ... SELECT ... WHERE NOT EXISTS ... |
| Previous Message | David G Johnston | 2014-08-28 00:07:16 | Re: Atomicity of INSERT INTO ... SELECT ... WHERE NOT EXISTS ... |