Re: A neutral challenge.
From: Lauri Pietarinen <lauri.pietarinen_at_atbusiness.com>
Date: Sat, 28 Jun 2003 11:32:35 +0300
Message-ID: <3EFD52A3.C699C075_at_atbusiness.com>
Date: Sat, 28 Jun 2003 11:32:35 +0300
Message-ID: <3EFD52A3.C699C075_at_atbusiness.com>
Bob Badour wrote:
> > I think using types for this purpose is a slight overkill. It would be
> > easy to add a 'day of week' and
> > a 'day of week in month' column into materialised calendar and just use
> > them in selection criterias.
>
> This would complicate queries too much. If one wants to see the events on
> thursday, one would have to query three or more columns instead of querying
> a single interval column.
OK, maybe I am a bit to used to thinking in SQL. How would your solution look like, using types?
Lauri Received on Sat Jun 28 2003 - 10:32:35 CEST