-- -- workflow_case_pkg__get_pretty_state/2 -- create or replace function workflow_case_pkg__get_pretty_state( character varying, integer ) returns varchar as $$ declare p_workflow_short_name alias for $1; p_object_id alias for $2; v_state_pretty varchar; begin select s.pretty_name into v_state_pretty from workflows w, workflow_cases c, workflow_case_fsm cfsm, workflow_fsm_states s where w.short_name = p_workflow_short_name and c.object_id = p_object_id and c.workflow_id = w.workflow_id and cfsm.case_id = c.case_id and s.state_id = cfsm.current_state; return v_state_pretty; end; $$ language plpgsql;