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
обсуждение исходный текст
Ответ на Can object oriented table design help to solve this problem?  ("Alan T. Miller" <amiller@hollywood101.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Alan T. Miller"
Дата:
Сообщение: Can object oriented table design help to solve this problem?
Следующее
От: Darko Prenosil
Дата:
Сообщение: Re: ??? Multiple selects in procedure