searching time arrays

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