Postgres Pro
Downloads
Home   >   mailing lists

Re: how to query against nested hstore data type - Mailing list pgsql-general

From John R Pierce
Subject Re: how to query against nested hstore data type
Date
Msg-id 53FBE1D8.5000601@hogranch.com
Whole thread Raw
In response to how to query against nested hstore data type  ("Huang, Suya" <Suya.Huang@au.experian.com>)
List pgsql-general
Tree view
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 pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-general by date:

Previous
From: "Huang, Suya"
Date:
Subject: Re: how to query against nested hstore data type
Next
From: Rajesh K
Date:
Subject: PostgreSQL DB Replication