From: Scott Marlowe <scott.marlowe@gmail.com>
To: Paul Lambert <paul.lambert@reynolds.com.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: Query design assistance - getting daily totals
Date: Wed, 12 Dec 2007 09:48:05 -0600
Message-ID: <dcc563d10712120748t2ea3629fl9e9a578e00330f45@mail.gmail.com> (raw)
In-Reply-To: <475F8234.5090907@reynolds.com.au>
References: <475F3AAB.2050609@reynolds.com.au>
<20071212063142.GA26523@a-kretschmer.de>
<475F8234.5090907@reynolds.com.au>
On Dec 12, 2007 12:39 AM, Paul Lambert <paul.lambert@reynolds.com.au> wrote:
> 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'm not sure that really justifies your method though. Not saying
"you're doing it wrong" so much as I'm not sure the way you're doing
it makes it any easier to keep track of certain periods. Any method
you would use to pick rows with the disjointed dates could be applied
to date and / or timestamp types as easily, and with some functional
indexes on the date / timestamp columns you could easily select
periods quickly as well.
Just saying.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: scott.marlowe@gmail.com, paul.lambert@reynolds.com.au
Subject: Re: Query design assistance - getting daily totals
In-Reply-To: <dcc563d10712120748t2ea3629fl9e9a578e00330f45@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox