postgresql7.1
select rr_rooms__edit(:room_id,
:name,
:facility_id,
:description,
:capacity,
:phone,
:approval_needed_p,
:edit_user,
:edit_ip)
select rr_rooms__delete(:room_id)
select rr_rooms__name(:room_id)
select r.reservation_id,
f.name as facility_name,
fr.name as room_name,
r.status,
to_char(start_date, 'Mon DD, YYYY HH12:MI AM') as full_start_date,
to_char(end_date, 'Mon DD, YYYY HH12:MI AM') as full_end_date,
e.name,
p.first_names||' '||p.last_name as username
from acs_events e join timespans s
on (e.timespan_id = s.timespan_id)
join time_intervals t
on (s.interval_id = t.interval_id)
join rr_reservations r
on (e.event_id = r.reservation_id)
join $rooms_table fr
on (r.room_id = fr.room_id)
join $facilities_table f
on (f.facility_id = fr.facility_id)
join persons p
on (r.reserving_user = p.person_id)
$condition_sql
order by start_date