From: | "Brian C(dot) Doyle" <bcdoyle(at)mindspring(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Complex Query Help |
Date: | 2001-03-21 13:07:56 |
Message-ID: | 5.0.2.1.2.20010321080320.02f98360@pop.internal.mindspring.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello all,
I have a table of work shifts. It has
Table "teams"
Attribute | Type | Modifier
------------+---------------+----------
team_id | varchar(50) |
team_name | varchar(100) |
location | varchar(100) |
department | varchar(100) |
shift | varchar(100) |
start_time | numeric(30,6) |
end_time | numeric(30,6) |
mon | boolean |
tue | boolean |
wen | boolean |
thu | boolean |
fri | boolean |
sat | boolean |
sun | boolean |
start_day | char(3) |
end_day | char(3) |
What I need to be able to do is select team_name where team works between a
time span ie teams that work between 730 and 1600 how would I do this????
What type of field should i sue for start_time and end_time?
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-03-21 13:20:22 | Re: Maybe a Bug, maybe bad SQL |
Previous Message | D'Arcy J.M. Cain | 2001-03-21 12:06:17 | Re: Maybe a Bug, maybe bad SQL |