On Fri, Oct 27, 2000 at 02:13:07PM +0200, Peter Pilsl wrote:
> On Fri, Oct 27, 2000 at 04:13:13AM -0700, Mike E wrote:
> > I have the following setup:
> >
> > appt=# select * from availability \g
> > emp_id | date | start_time | end_time
> > --------+------------+------------+----------
> > 1 | 2000-10-30 | 08:00:00 | 14:30:00
> >
> > appt=# select * from appointments \g
> > start_time | end_time | emp_id | cus_id | services | date
> > ------------+----------+--------+--------+----------+------------
> > 09:00:00 | 11:30:00 | 1 | 2 | {1,2,3} | 2000-10-30
> >
> > Now, what I would like to get is the following:
> >
> > start_time | end_time
> > ------------+----------
> > 08:00:00 | 09:00:00
> > 11:30:00 | 14:30:00
> >
>
> not sure about the exact syntax, but to give you an idea:
That was just an example. What I would like to do is for any given
range of availabilty, take all the appointments, subtract/difference
them out and get a result set of all the time slots that are left.
Is this something that can be done in SQL, or will I have to pull
all the relevant data out and do all the logic in my application?
I will have a varying number of appointments on each day, which
possibly more than one availability record as well.
Thanks,
Mike
--
Mike Erickson <mee@quidquam> http://www.quidquam.com/
"Hatred is the coward's revenge for being intimidated" - George Bernard Shaw