Greetings SQLians;
given the table below, how would i determine which name is
avail on a givin day at a givin time? the time arrays
contain an a list of hours a support person is available;
'{09:00:00,10:00:00,11:00:00,12:00:00}' etc.
any thoughts?
thanxnatez
CREATE TABLE support_sched
( name varchar(30), monday time[], tuesday time[], wednesday time[], thursday time[], friday time[],
saturday time[], sunday time[]
);
Nate Gelbard office: 503.284.0369
Straylight Research fax : 516.828.8533