Re: [GENERAL] how to query against nested hstore data type

2014-08-27 Thread Huang, Suya
-Original Message- From: Adrian Klaver [mailto:adrian.kla...@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

Re: [GENERAL] how to query against nested hstore data type

2014-08-26 Thread Adrian Klaver
On 08/26/2014 06:50 PM, Huang, Suya wrote: -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, August 26, 2014 11:58 PM To: Huang, Suya; pgsql-general@postgresql.org I've figured out, have to apply a separate patch to query out of nested hsto

Re: [GENERAL] how to query against nested hstore data type

2014-08-26 Thread Huang, Suya
-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, August 26, 2014 11:58 PM To: Huang, Suya; pgsql-general@postgresql.org Subject: Re: [GENERAL] how to query against nested hstore data type On 08/25/2014 06:05 PM, Huang, Suya wrote: > -Origi

Re: [GENERAL] how to query against nested hstore data type

2014-08-26 Thread Adrian Klaver
On 08/25/2014 06:05 PM, Huang, Suya wrote: -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Monday, August 25, 2014 11:42 PM To: Huang, Suya; pgsql-general@postgresql.org Subject: Re: [GENERAL] how to query against nested hstore data type On 08/24/2014 07

Re: [GENERAL] how to query against nested hstore data type

2014-08-25 Thread John R Pierce
On 8/24/2014 7:05 PM, Huang, Suya wrote: The question is how can I get visits/pages/duration separately from the value column so that I can do a sum on those metrics individually. why not store all this in proper relational tables so you can use proper relational queries? -- john r pie

Re: [GENERAL] how to query against nested hstore data type

2014-08-25 Thread Huang, Suya
-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Monday, August 25, 2014 11:42 PM To: Huang, Suya; pgsql-general@postgresql.org Subject: Re: [GENERAL] how to query against nested hstore data type On 08/24/2014 07:05 PM, Huang, Suya wrote: > Hi, > >

Re: [GENERAL] how to query against nested hstore data type

2014-08-25 Thread Adrian Klaver
On 08/24/2014 07:05 PM, Huang, Suya wrote: Hi, It’s my test DB, the version is PostgreSQL 9.4beta2. I’m testing with nested hstore feature. testdb=# \d+ test Table "public.test" Column | Type | Modifiers | Storage | Stats target | Description ++--

Re: [GENERAL] how to query against nested hstore data type

2014-08-24 Thread Huang, Suya
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Huang, Suya Sent: Monday, August 25, 2014 12:18 PM To: Peter Geoghegan Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] how to query against nested hstore data type

Re: [GENERAL] how to query against nested hstore data type

2014-08-24 Thread Huang, Suya
-Original Message- From: Peter Geoghegan [mailto:peter.geoghega...@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 wrote

Re: [GENERAL] how to query against nested hstore data type

2014-08-24 Thread Peter Geoghegan
On Sun, Aug 24, 2014 at 7:05 PM, Huang, Suya 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 -- Sent via pg

[GENERAL] how to query against nested hstore data type

2014-08-24 Thread Huang, Suya
Hi, It's my test DB, the version is PostgreSQL 9.4beta2. I'm testing with nested hstore feature. testdb=# \d+ test Table "public.test" Column | Type | Modifiers | Storage | Stats target | Description ++---+--+--+