Complex Query Help

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?

Browse pgsql-sql by date

  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