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

Поиск
Список
Период
Сортировка
Искать
От
Jeffrey Melloy
Тема
Re: Can object oriented table design help to solve this problem?
Дата
Msg-id
6B812B4A-3107-11D7-8CB3-000A95765962@visualdistortion.org
Ответ на
Список
Дерево обсуждения
Documentation needs significant improvement Chris Johnson <chris@chaska.com>
Re: Documentation needs significant improvement will trillich <will@serensoft.com>
Re: Documentation needs significant improvement Lincoln Yeoh <lyeoh@pop.jaring.my>
Re: Documentation needs significant improvement Chris Johnson <chris@chaska.com>
Re: Documentation needs significant improvement Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: Documentation needs significant improvement will trillich <will@serensoft.com>
Re: Documentation needs significant improvement "Shridhar Daithankar<shridhar_daithankar@persistent.co.in>" <shridhar_daithankar@persistent.co.in>
Re: Documentation needs significant improvement "Ron St.Pierre" <rstpierre@syscor.com>
Re: Documentation needs significant improvement Bruno Wolff III <bruno@wolff.to>
ALTER STATISTIC and dump ? Hervé Piedvache <herve@elma.fr>
Re: ALTER STATISTIC and dump ? Tom Lane <tgl@sss.pgh.pa.us>
Re: Documentation needs significant improvement Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
Re: Documentation needs significant improvement Tom Lane <tgl@sss.pgh.pa.us>
Re: Documentation needs significant improvement will trillich <will@serensoft.com>
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

В списке pgsql-general по дате отправления
От: Alan T. Miller
Дата:
От: Darko Prenosil
Дата:
FAQ