--
-- bt_bug__bug_type_sort_order/1
--
create or replace function bt_bug__bug_type_sort_order(
  character varying
) returns int4 as $$

declare
    p_bug_type                  alias for $1;
    v_sort_order                integer;
begin
    v_sort_order := case p_bug_type
        when 'bug'        then 1
        when 'suggestion' then 2
        when 'todo'       then 3
                            else 4
    end;

    return v_sort_order;
end;
$$ language plpgsql;