如何在plpgsql postgresql中将变量声明为散列或字典类型

Question

我有数据作为哈希 -> key:value

cc_to_name_dict = {
"00": "Unknown",
"AW": "Aruba",
"AG": "Antigua and Barbuda",
"AE": "United Arab Emirates"}

如何将此数据存储在变量中以在函数中使用它，就像

Create  OR REPLACE function convert__gender__gender__from__integer__to__string(gender_int integer)
returns varchar
language plpgsql
as
$$
    DECLARE gender_str varchar;
Begin
    if gender_int = 0 then
        gender_str := 'M';
    elsif gender_int = 1 then
        gender_str := 'F';
    elsif gender_int = 2 then
        gender_str := 'U';
    elsif gender_int is null then
        gender_str := null;
    else
        gender_str := -1;
    end if;

   return gender_str;
End
$$;

我需要通过字典变量的键返回值进行搜索