-- -- 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;