| From: | Nathan Gelbard <gelbardn(at)intus(dot)net> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | searching time arrays |
| Date: | 1999-08-19 18:37:37 |
| Message-ID: | Pine.GSO.3.96.990819113459.5869A-100000@floyd |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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?
thanx
natez
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-08-19 19:17:45 | Re: [SQL] searching time arrays |
| Previous Message | Jon Windfeld Bundesen | 1999-08-19 15:42:05 | What JDBC datatype can be used for DATETIME ? |