-----Original Message----- From: Peter Geoghegan [mailto:[email protected]] Sent: Monday, August 25, 2014 12:14 PM To: Huang, Suya Cc: [email protected] Subject: Re: [GENERAL] how to query against nested hstore data type
On Sun, Aug 24, 2014 at 7:05 PM, Huang, Suya <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
