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