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
all together using a date field. Eg, 1st January may actually be the
15th 'working day' of the 9th 'financial period' - however looking at
just a date of jan-1 there is no way of knowing this and it's the
periods that matter more so than the actual date.
I've given the function method a try and it looks to work efficiently
enough.
P.
--
Paul Lambert
Database Administrator
AutoLedgers - A Reynolds & Reynolds Company
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
