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