Re: Query design assistance - getting daily totals

Поиск
Список
Период
Сортировка
От A. Kretschmer
Тема Re: Query design assistance - getting daily totals
Дата
Msg-id 20071212072946.GC26523@a-kretschmer.de
обсуждение исходный текст
Ответ на Re: Query design assistance - getting daily totals  (Paul Lambert <paul.lambert@reynolds.com.au>)
Список pgsql-sql
am  Wed, dem 12.12.2007, um 15:39:48 +0900 mailte Paul Lambert folgendes:
> A. Kretschmer wrote:
> >am  Wed, dem 12.12.2007, um 10:34:35 +0900 mailte Paul Lambert folgendes:
> >>year_id integer
> >>month_id integer
> >>working_day integer
> >
> >Why this broken data types? We have date and timestamp[tz].
> >
> >
> 
> It's a financial application which needs to work using a concept of 
> 'financial periods' which may not necessarily correspond to calendar 
> months and it's much easier to manage in this way than it is to merge it 

Ahh, thanks for the explanation.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net


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

Предыдущее
От: Paul Lambert
Дата:
Сообщение: Re: Query design assistance - getting daily totals
Следующее
От: Gerry Reno
Дата:
Сообщение: Re: join on three tables is slow