-- -- acs_event__get_status_summary/1 -- create or replace function acs_event__get_status_summary( integer ) returns bool as $$ declare get_status_summary__event_id alias for $1; -- acs_events.event_id%TYPE v_status_summary acs_events.status_summary%TYPE; begin select coalesce(e.status_summary, a.status_summary) into v_status_summary from acs_events e left join acs_activities a on (e.activity_id = a.activity_id) where e.event_id = get_status_summary__event_id; return v_status_summary; end;$$ language plpgsql;