Re: Can object oriented table design help to solve this problem?

Jeffrey Melloy <jmelloy@visualdistortion.org>

From: Jeffrey Melloy <jmelloy@visualdistortion.org>
To: "Alan T. Miller" <amiller@hollywood101.com>
Cc: <pgsql-general@postgresql.org>
Date: 2003-01-26T08:23:16Z
Lists: pgsql-general
I would suggest a combination of both.  Have a table with a structure 
similar to the following:
TABLENAME:  Weekly Hits
Cols: ID_Property, week_start, hits

This way, you would have a new row for each property each week.  It's 
also easy to expand you search.  If you want to see how many hits a 
property got between March and June, say, that's an easy query to make 
(select sum(hits) from weekly_hits where week_start > '01-mar-03' and 
week_start < '30-jun-03' and prop_id = 42).

Hope this helps,
Jeffrey Melloy