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