Postgres函数获取首字母缩写
CREATE OR REPLACE FUNCTION "gethzpy"("ahzstr" varchar)
  RETURNS "pg_catalog"."varchar" AS $BODY$
/******************************************************************
功能说明:根据输入汉字返回汉字首字母(如果输入不是汉字则返回该输入字符)
创 建 人:张童瑶
创建日期:2021-11-10
返 回 值: 拼音首字母

使用样例:select gethzpy('你好')

修订日期:
修 订 人:
修订原因:
修改内容:
******************************************************************/

declare
  sresult varchar ;
    
begin
  with
    hzlb as(
      --传入参数列转行 
      select  
        regexp_split_to_table(ahzstr,'') as hzstr
    )
   ,asclb as(
      --
      select  
         hzstr
        ,ascii(hzstr) as asicchz
        from hzlb 
    )
   ,hzpdlb as (
      --根据字节数判定首字母
      select
        case when asicchz in (21834,38165,21956,21526,33100,38463) then 'a'
             when asicchz in (21696,21710,21769,21964,22003,22467,23250,25384,25457,26279,29233,29815,30284,30353,30702,30777,30861,33406,34108,38207,38552,38701)then 'ai'
             when asicchz in (20474,22511,23433,23736,24245,25353,25566,26263,26696,26697,27688,29364,33018,35865,38133,38797,40524,40687)then 'an'
             when asicchz in (26114,30414,32942)then 'ang'
             when asicchz in (20658,20985,22007,22387,22885,23210,23705,24274,25034,25303,25942,28595,29100,29522,32753,32881,34735,34948,36968,37834,37846,39580,40140)then 'ao'
             when asicchz in (20843,21485,21543,22365,23708,24052,25170,25226,25300,25420,28766,29240,30116,31494,31889,32610,32793,33453,33543,33757,36299,38063,38712,38774,39747,40069)then 'ba'
             when asicchz in (20336,25308,25453,25520,25670,26575,30333,30334,31255,36133)then 'bai'
             when asicchz in (20276,21150,21322,22338,25198,25203,25292,25644,26001,26495,29256,29677,29923,30242,30285,32458,33320,33324,38051,38442,39041)then 'ban'
             when asicchz in (20621,24110,26758,26834,27036,27996,30917,32465,33152,33953,34444,35876,37030,38225)then 'bang'
             when asicchz in (20445,21093,21241,21253,22561,23394,23453,25253,25265,26292,26333,28689,28846,29042,29190,32990,33502,33862,34180,35090,35091,35961,36277,38649,39281,40077,40488,40837)then 'bao'
             when asicchz in (20493,21271,21329,21591,22791,23387,24726,24754,24811,26479,28953,29384,30865,30874,32972,34003,34987,35097,36125,36744,37046,37950,38049,38466,38836,40526)then 'bei'
             when asicchz in (22348,22831,22868,26412,30042,31528,33519,38171)then 'ben'
             when asicchz in (22051,23849,27893,29967,29997,32503,36454,36856)then 'beng'
             when asicchz in (20478,21269,21537,21716,22721,22947,23138,23318,24065,24199,24243,24330,24380,24444,24517,24846,25949,26610,27604,27605,27606,27609,28375,28638,29428,29863,30016,30201,30565,30887,31189,31508,31578,31621,31718,33218,33325,33432,33628,33656,33798,34006,34109,34204,35048,35166,36146,36344,36767,36924,36991,37145,38091,38381,38491,39616,40763)then 'bi'
             when asicchz in (20415,21310,21342,21464,24321,24557,25153,27764,29048,30765,30885,31366,31550,32527,32534,33476,34649,35082,36140,36776,36777,36779,36793,36941,38829,40138)then 'bian'
             when asicchz in (23114,24426,26631,30253,33176,34920,35057,38230,38259,39121,39129,39130,39584,40148)then 'biao'
             when asicchz in (21035,24971,30250,36457,40150)then 'bie'
             when asicchz in (20647,23486,24428,25672,25996,27103,27553,28392,28626,29602,32548,33169,35955,38228,39628,39699)then 'bin'
             when asicchz in (19993,20853,20912,23631,24182,25682,26564,28851,30149,31104,31177,37044,39292)then 'bing'
             when asicchz in (20147,20271,21187,21338,21877,24091,25320,25615,25773,25816,27287,27850,27874,28001,28196,29627,31028,31636,31800,33046,33162,33334,33760,36315,36387,38069,38073,38082,39293,39539,40513)then 'bo'
             when asicchz in (19981,21340,21343,21754,22484,22496,24067,24598,25429,26209,27493,29951,31807,34917,36875,37096,37293,38042,38072)then 'bu'
             when asicchz in (22163,25830,31012)then 'ca'
             when asicchz in (24425,25165,26448,29468,30572,33756,34081,35009,36130,36393,37319)then 'cai'
             when asicchz in (21442,24808,24813,27531,28799,29864,31922,34453,39184,39574,40682)then 'can'
             when asicchz in (20179,20263,27815,33329,33485,34255)then 'cang'
             when asicchz in (22024,25805,26361,27133,28437,31961,33370,33609,34732)then 'cao'
             when asicchz in (20391,20876,21397,24699,27979,31574)then 'ce'
             when asicchz in (23697,28052)then 'cen'
             when asicchz in (22092,23618,26366,36461)then 'ceng'
             when asicchz in (21049,21449,21939,23033,23519,23700,24046,25554,25661,26440,26597,26946,27086,27307,27722,29497,30900,33580,33590,34921,35815,38200,38258,39303)then 'cha'
             when asicchz in (20394,25286,26612,30245,34431,35962,38039)then 'chai'
             when asicchz in (20135,20865,23157,23409,24283,24527,25530,25600,28538,28598,31109,32544,32700,33927,34633,34814,35271,35844,35863,36500,38130,38416,39076,39307,39587)then 'chan'
             when asicchz in (20261,20513,20607,21378,21809,22330,23100,23270,23581,24120,24476,24581,24797,25950,26124,26166,27653,29462,30021,32928,33484,33750,35059,38271,38410,39727,40115)then 'chang'
             when asicchz in (21119,21557,22066,24034,24586,25220,26177,26397,28526,28818,28975,32790,36229,38046)then 'chao'
             when asicchz in (22396,24443,25199,25507,25764,28552,30743,36710)then 'che'
             when asicchz in (21972,23480,23576,24561,25275,26216,27015,27784,27785,29723,30876,33251,34924,35852,35894,36225,36784,37108,38472,40832)then 'chen'
             when asicchz in (19998,20056,21576,22478,22485,22605,24809,25104,25215,25745,26536,26621,27225,28548,29685,29732,30624,31204,31216,31243,34511,35022,35802,36894,37234,38102,38107,39563)then 'cheng'
             when asicchz in (20360,20666,21273,21489,21507,21735,21883,21988,22656,23224,23610,24347,24435,25345,25941,26021,27744,28861,30196,30235,30517,31518,31722,32709,32827,33548,34473,34733,35115,35913,36196,36383,36831,39276,39536,39761,40497,40831)then 'chi'
             when asicchz in (20805,20914,23456,23815,24545,24999,33282,33375,33594,34411,37325,38131)then 'chong'
             when asicchz in (19985,20167,20454,24113,24774,24833,25277,30068,30259,30597,31264,31609,32504,33261,36364,37228,38624)then 'chou'
             when asicchz in (20109,20648,20986,21005,21021,21416,22788,24629,25015,25616,26485,26970,26990,27159,27249,28353,30044,30679,30784,32460,34573,35098,35302,36464,36487,38148,38500,38607,40668)then 'chu'
             when asicchz in (22060,25571,25611,33194,36409)then 'chuai'
             when asicchz in (20018,20256,21912,24029,26941,27674,31359,33307,33313,33337,36932,38031)then 'chuan'
             when asicchz in (21019,24162,24202,24582,30126,31383,38383)then 'chuang'
             when asicchz in (21561,22402,25462,26864,26894,27084,28810,38180,38514)then 'chui'
             when asicchz in (21767,26149,26943,28147,32431,33724,34685,34850,37255,40529)then 'chun'
             when asicchz in (21852,25139,32496,36372,36749,40842)then 'chuo'
             when asicchz in (21050,24904,27425,27492,29943,30133,30913,31072,31949,33544,33576,35789,36176,36766,38604,40538)then 'ci'
             when asicchz in (19995,20174,21254,22257,26526,28121,29742,29825,32874,33473,33905,39586)then 'cong'
             when asicchz in (20945,26993,33120,36751)then 'cou'
             when asicchz in (20419,21330,24450,27522,29469,31751,31895,34079,36441,36468,37218,37259)then 'cu'
             when asicchz in (25786,25874,27718,29224,31388,31713,36479,38249)then 'cuan'
             when asicchz in (20652,21840,23828,24756,25703,27057,27635,28140,29824,30209,31929,32736,33030,33795,34928)then 'cui'
             when asicchz in (23384,23544,24534,26449,30388)then 'cun'
             when asicchz in (21405,23919,25387,25514,25619,25774,30180,30700,30923,33054,36425,38153,38169,40574)then 'cuo'
             when asicchz in (21714,21970,22231,22823,22962,24603,25171,25645,27795,30249,31530,31572,32823,35105,36798,38780,38801)then 'da'
             when asicchz in (20195,20643,21574,21588,22509,23729,24102,24453,24608,25140,27513,27526,29619,29977,32464,34955,36151,36840,36910,40667)then 'dai'
             when asicchz in (20025,20294,20747,20988,21333,21846,23445,24377,24814,25285,25528,26086,27546,27694,28129,28601,30136,30213,30472,30707,31658,32829,32835,32966,33770,33807,34507,35806,36181,37112)then 'dan'
             when asicchz in (20826,24403,25377,26723,30720,33633,35014,35872,38107)then 'dang'
             when asicchz in (20498,20992,21040,21480,23548,23707,24764,25443,27672,28952,30423,31095,31291,32411,36424,36947)then 'dao'
             when asicchz in (24471,24503,30340,38173)then 'de'
             when asicchz in (20979,22100,23965,25125,28783,30331,30634,30964,31561,31782,36460,37011,38251)then 'deng'
             when asicchz in (20302,22016,22320,22395,22564,23075,23265,24093,24213,24351,25269,25932,26594,26851,27664,28068,28404,29380,30535,30757,30898,31063,31515,31532,31860,32532,32669,32735,33659,33922,35276,35787,35867,36842,36882,37048,38237,39606)then 'di'
             when asicchz in (22002)then 'dia'
             when asicchz in (20022,20291,20856,22379,22443,22880,24005,24215,24806,25474,27583,28096,28359,28857,29623,30005,30008,30300,30315,30872,31775,36398,38079,38461,38747,39072)then 'dian'
             when asicchz in (20939,20993,21500,21514,25481,30857,35843,35970,38035,38110,38613,40119)then 'diao'
             when asicchz in (21472,21899,22436,22558,25586,29241,29266,29918,30879,32779,34678,35853,36300,36845,40125)then 'die'
             when asicchz in (19969,20163,21486,21878,23450,29582,30010,30100,30447,30855,32821,33114,35746,37194,38025,38189,39030,40718)then 'ding'
             when asicchz in (20002,38117)then 'diu'
             when asicchz in (19996,20375,20908,20923,21160,21658,22412,23741,23762,24683,25026,26635,27681,27934,30800,33000,33012,33891,40491)then 'dong'
             when asicchz in (20828,25238,26007,30168,31398,31740,34104,34474,35910,36887,37117,38061,38497)then 'dou'
             when asicchz in (22047,22581,22930,24230,26460,26911,27602,28174,28193,29261,29322,29420,30563,30585,31491,32922,33423,34873,35835,36172,38208,39633,40681)then 'du'
             when asicchz in (26029,26932,27573,28997,30701,31471,31766,32526,38203)then 'duan'
             when asicchz in (20817,22534,23545,24636,24989,30867,38246,38431)then 'dui'
             when asicchz in (21544,22244,22697,25958,27788,28822,30457,30462,30744,30981,36280,36466,36929,38045,39039)then 'dun'
             when asicchz in (21057,21636,21702,21722,22427,22549,22810,22842,24816,25479,26421,27826,32525,33333,35056,36346,36401,36530,38094)then 'duo'
             when asicchz in (20420,21380,21571,21734,22121,22441,23077,23104,23641,23784,24694,24853,25212,33133,33482,33706,33852,34558,35769,35860,36717,36943,37122,38151,38199,38463,39066,39069,39295,40132,40517,40535)then 'e'
             when asicchz in (35830)then 'ei'
             when asicchz in (21999,24681,25665,33981)then 'en'
             when asicchz in (20108,20799,23572,27953,29669,32780,32819,36144,36841,38098,39285,40085,40504)then 'er'
             when asicchz in (20047,20240,21457,22433,27861,29648,30749,31567,32602,38400)then 'fa'
             when asicchz in (20961,21453,22786,24070,24161,25909,26805,27146,27867,28735,28902,29140,29359,30024,30058,30718,32321,32763,33539,34115,34281,34345,36137,36463,36820,38034,39277)then 'fan'
             when asicchz in (20223,22346,22952,25151,25918,26041,26507,32442,32938,33323,33459,35775,37025,38059,38450,40066)then 'fang'
             when asicchz in (21290,21536,21857,22915,24223,24753,25161,26000,27047,27832,28125,29394,30193,30761,31706,32495,32737,32933,32954,33107,33778,34586,35837,36153,38212,38671,38750,39134,40113)then 'fei'
             when asicchz in (20221,20606,20998,21545,22367,22859,24575,24868,26876,27675,27774,28725,28954,31881,31914,32439,33452,37210,40124,40738)then 'fen'
             when asicchz in (20016,20472,20911,20964,21802,22857,23553,23792,26539,27811,28925,30127,30748,32541,33873,34562,35773,36898,37190,38155,39118)then 'feng'
             when asicchz in (20315)then 'fo'
             when asicchz in (21542,32566)then 'fou'
             when asicchz in (20184,20239,20440,20463,20613,20971,21103,21264,21579,21586,21648,22797,22827,22919,23386,23413,23500,24133,24158,24220,24343,24619,25206,25242,25282,25290,25975,26023,26381,26740,27679,28014,28074,28367,29238,29995,31059,31119,31235,31526,32450,32459,32538,32600,32932,33071,33104,33105,33145,33396,33433,33470,33531,33583,33670,33705,33748,34472,34569,34656,34670,34993,35206,35747,36127,36171,36185,36212,36282,36311,36741,36752,37083,37340,38428,38468,39333,39544,40075,40134,40632,40699,40700)then 'fu'
             when asicchz in (22030,22134,22419,22841,23573,23580,23596,26094,36711,38022)then 'ga'
             when asicchz in (19984,25124,25913,27010,28297,30422,33445,35813,36165,38041,38484)then 'gai'
             when asicchz in (22377,23604,24178,24863,25792,25954,26096,26438,26577,27204,27860,28134,28553,29976,30131,30712,31174,31487,32448,32925,33527,36195,36214,37200)then 'gan'
             when asicchz in (20872,21018,23703,25094,26464,28207,31611,32434,32568,32609,32923,38050)then 'gang'
             when asicchz in (21578,25630,26482,27073,27092,30347,30590,31295,31705,31957,32543,32660,33167,34241,35824,37084,38150,38224,39640)then 'gao'
             when asicchz in (20010,20193,21106,21508,21512,21679,21733,21759,21981,22314,22629,25096,25601,25663,26684,27468,30105,30796,32421,33011,33160,33336,33883,34428,34532,35004,38124,38217,38401,38548,38761,39052,39612,39730,40509)then 'ge'
             when asicchz in (32473)then 'gei'
             when asicchz in (20120,21711,26681,33390,33563,36319)then 'gen'
             when asicchz in (21757,22466,24218,26356,26775,32480,32697,32789,32831,36179,40096)then 'geng'
             when asicchz in (20379,20844,20849,21151,22632,23467,24037,24041,24339,24685,25329,25915,27742,29657,32945,34467,35301,36129,36524,40858)then 'gong'
             when asicchz in (20317,21246,22434,22815,23230,23715,24384,26500,26552,27807,29399,31537,31709,32529,33503,35279,35807,36141,36952,38057,38834)then 'gou'
             when asicchz in (20272,21476,21653,22031,22266,22993,23396,23854,25925,26767,27586,27753,27837,29295,29311,30204,30653,31629,32607,32929,33228,33735,33776,34500,34506,35290,35778,35895,36158,36721,36764,37220,38068,38178,38599,39038,39592,40116,40490,40516,40536,40723)then 'gu'
             when asicchz in (21038,21072,21350,21617,23521,25346,26653,29916,32973,35074,35798,40505)then 'gua'
             when asicchz in (20054,24618,25296,25524)then 'guai'
             when asicchz in (20492,20851,20896,23448,24815,25532,26874,28075,28748,30437,30684,31649,32438,32592,33694,35266,36143,39302,40143,40563)then 'guan'
             when asicchz in (20809,21667,24191,26692,29367,33009,36891)then 'guang'
             when asicchz in (21053,21055,21286,22317,22955,23428,24203,24402,26231,26588,26690,26727,28805,29808,30328,30344,30789,31755,35268,35809,36149,36330,36712,38394,39740,40081,40156,40863)then 'gui'
             when asicchz in (26829,28378,30937,32498,34926,36746,40103)then 'gun'
             when asicchz in (21593,22269,22490,23838,24124,26524,26881,29459,32850,34402,34622,34632,35065,36807,37101,38149,39320)then 'guo'
             when asicchz in (21704,34532,38122)then 'ha'
             when asicchz in (20133,21992,23401,23475,27686,28023,33010,37282,39559,39608)then 'hai'
             when asicchz in (20989,21547,21898,23506,24717,25000,25022,25421,25750,25788,26097,26199,27721,27735,27995,28085,28698,28938,28947,29364,32597,32752,33761,34486,37015,37039,37219,38426,38889,39032,39060,40766)then 'han'
             when asicchz in (21549,22831,26477,27782,32471,33322,34892,39043)then 'hang'
             when asicchz in (21495,21989,22150,22158,22741,22909,26122,27627,28009,28111,28640,28751,30355,32791,33983,34181,34461,35946,37085,39074)then 'hao'
             when asicchz in (20309,21182,21512,21621,21644,21917,21996,22737,26359,26680,27827,28088,30413,30418,31166,32750,33655,33743,34485,35088,35779,35977,36154,36203,38402,38422,39052,40548)then 'he'
             when asicchz in (22079,40657)then 'hei'
             when asicchz in (24456,24680,29408,30165)then 'hen'
             when asicchz in (20136,21756,24658,26689,27178,29673,34309,34913)then 'heng'
             when asicchz in (21700,23439,24344,27859,27946,28888,32418,33645,34171,34216,34425,35335,35751,36720,38387,40511,40649)then 'hong'
             when asicchz in (20399,20505,21402,21518,21564,21897,22560,24460,29492,30218,31692,31943,36869,39610,40078)then 'hou'
             when asicchz in (20046,20114,20913,21628,21804,21823,22251,22774,23733,24359,24573,24601,24794,25143,25149,25160,25252,26011,27122,27818,27986,28246,28409,28864,29043,29392,29474,29733,29786,29920,31068,31503,31946,32993,33899,34382,34676,35315,36727,37264,40516,40533,40536,40561)then 'hu'
             when asicchz in (21010,21270,21326,21719,26726,28369,29502,30011,30729,33457,35805,38119,39557)then 'hua'
             when asicchz in (22351,24458,24576,27088,28142,36381)then 'huai'
             when asicchz in (21796,22300,22850,23462,23536,24187,24739,25442,25808,26707,27426,27961,28003,28067,28470,28949,29566,29615,30186,32531,32563,33809,35938,36824,36909,37063,38206,39711,40105)then 'huan'
             when asicchz in (20976,24140,24488,24653,24822,24908,26179,28255,28514,29004,29852,30272,30343,30970,31681,31783,32915,33618,34647,34789,35854,36945,38541,40135,40644)then 'huang'
             when asicchz in (20250,21321,21684,21913,22238,24407,24509,24666,24674,24724,24800,24935,25381,26198,26214,26727,27585,27719,27908,28784,28905,29682,31229,32472,32523,33588,33631,34137,34426,34516,34794,35763,35801,35826,36159,36745,38579,40638)then 'hui'
             when asicchz in (23130,26127,27985,28151,28343,33636,35816,38413,39300,39746)then 'hun'
             when asicchz in (20249,21136,22191,22821,24785,25110,25865,27963,28779,31096,32800,33719,34303,34838,35905,36135,38060,38186,38252,38669)then 'huo'
             when asicchz in (20073,20127,20238,20342,20552,20864,20960,20987,21058,21086,21363,21450,21501,21513,21677,21724,21799,22334,22522,22716,22931,23020,23241,23395,23490,23492,23632,23692,23879,23924,24049,24524,24613,24760,25119,25122,25216,25380,25486,26082,26280,26426,26497,26840,26987,27547,27762,27918,27982,28608,29316,29585,30072,30079,30142,30240,30710,31085,31215,31287,31293,31492,31496,31637,31821,31995,32423,32426,32473,32487,32489,32521,32641,32908,33034,33448,33456,33632,33978,34015,34170,34414,35274,35745,35749,35760,36173,36347,36349,36753,36857,38469,38598,38657,39269,39569,39589,39675,40090,40107,40481,40578,40785)then 'ji'
             when asicchz in (20215,20285,20339,20551,21152,22025,22841,23233,23478,23724,24669,25115,26550,26551,27971,29640,30002,30146,30229,31292,31539,32987,33540,33626,33901,34545,34952,36158,36303,36838,37071,38078,38103,38227,39050,39550)then 'jia'
             when asicchz in (20214,20461,20581,20717,20860,20943,21073,21098,22237,22362,22904,23574,24314,25099,25132,25315,25441,25627,26535,26604,26816,26967,27099,27516,27645,28071,28176,28244,28293,29006,29294,29325,30417,30545,30839,30897,31509,31546,31616,31661,32516,32547,32742,32937,33137,33328,33392,33575,33616,33733,33977,35045,35265,35591,35855,35883,36145,36341,36410,36423,37492,38159,38190,38388,38831,39279,40099,40547)then 'jian'
             when asicchz in (20725,21280,22870,23004,23558,24378,26728,27743,27930,27974,29343,30086,30995,31976,32475,32560,32809,33587,33931,35762,35911,37233,38477,38739)then 'jiang'
             when asicchz in (20132,20348,20389,20716,21119,21483,22093,22204,23011,23047,23780,24508,25378,25605,25945,25963,26657,26898,27975,28267,28966,29409,30350,30699,30977,31382,32478,32564,33014,33050,33405,33581,34121,34527,35282,36324,36735,36739,37066,37237,37294,38128,39290,39556,40091,40554)then 'jiao'
             when asicchz in (20171,20511,21163,21180,21896,21983,22992,23125,23377,23626,25106,25130,25326,25463,25509,25581,26480,26688,26708,27905,30028,30102,30117,30342,30571,30883,31224,31469,32467,32687,33410,33445,34249,34471,34903,35299,35750,35800,35819,38454,39049,39601,40082)then 'jie'
             when asicchz in (20165,20170,21170,21370,22116,22535,22935,23613,24062,24273,26020,26187,27135,27941,28024,28908,29710,29822,30684,31105,31563,32039,32537,33641,34943,35167,35280,35880,36166,36817,36827,37329,38182,38771,39313)then 'jin'
             when asicchz in (20117,20140,20742,20834,20928,21037,22659,23143,24362,24452,24778,25004,25964,26060,26223,26230,27902,29517,29855,30153,30555,31454,31455,31632,31923,31934,32463,32956,33003,33096,33550,33606,33729,35686,36851,38236,38449,38742,38745,39048,40120)then 'jing'
             when asicchz in (25155,28847,31384,36837)then 'jiong'
             when asicchz in (20037,20061,20710,21417,21646,21886,23601,25578,25937,26087,26601,26709,28792,29590,30106,31350,32416,33276,33285,36211,37202,38404,38893,39695,40480,40555)then 'jiu'
             when asicchz in (19988,20030,20465,20520,20855,21095,21477,21632,23616,23621,23654,24040,24807,25298,25304,25454,25516,26552,26896,27017,27032,27224,27822,28844,29323,29401,29722,30141,30697,31405,32858,33507,33524,33682,33738,35070,35765,36228,36317,36382,36413,36710,36989,37301,38044,38164,38191,38606,38816,38827,39123,39545,40835)then 'ju'
             when asicchz in (20518,21367,23071,25424,26698,28051,29431,30519,32482,34866,37124,38185,38220,38589,40515)then 'juan'
             when asicchz in (20500,20915,21122,21413,22104,22129,23379,23835,25225,25496,25733,25899,26743,27227,29213,29237,29527,29647,30669,32477,34152,35273,35286,35776,35890,36470,38242)then 'jue'
             when asicchz in (20426,20891,21531,22343,23803,25411,27994,29690,30386,31459,31584,33740,37089,38055,39567,40583)then 'jun'
             when asicchz in (20327,21345,21652,21654,21679,21888,33001)then 'ka'
             when asicchz in (20975,21056,22450,24320,24574,24698,24936,25577,26999,33928,38112,38158,38196)then 'kai'
             when asicchz in (20355,21002,21208,22350,22570,25121,27099,30475,30640,30733,33712,38426,40859)then 'kan'
             when asicchz in (20130,20233,24247,24951,25179,25239,28821,31968,38058,38390)then 'kang'
             when asicchz in (23611,25335,26674,28900,29330,32771,38096,38752)then 'kao'
             when asicchz in (20811,21051,21487,21683,21969,22391,22771,23458,23714,24682,26607,26869,27690,28212,28312,29634,30132,30604,30933,31185,31262,31392,32514,33499,34636,35838,36722,38070,38174,39055,39063,39570,39617)then 'ke'
             when asicchz in (21827,22438,24691,32943,35017,40840)then 'ken'
             when asicchz in (21549,22353,38143)then 'keng'
             when asicchz in (20517,23380,23814,24656,25511,31354,31644)then 'kong'
             when asicchz in (21475,21481,22231,23495,25187,25248,30477,31576,33444,34107)then 'kou'
             when asicchz in (21043,21741,21950,22528,24211,26543,31391,32468,33510,35044,37239,39607)then 'ku'
             when asicchz in (20361,22446,22840,25358,33007,36328)then 'kua'
             when asicchz in (20250,20393,21721,22359,24555,27981,29423,31607,33037,33967,37072)then 'kuai'
             when asicchz in (23485,27454,39627)then 'kuan'
             when asicchz in (20917,21281,21712,22329,22844,26103,26694,29378,30518,30719,31568,32425,35795,35827,36150,37021)then 'kuang'
             when asicchz in (20111,20608,21294,21919,21945,22804,22862,23743,24733,24870,24871,25542,26252,28291,30420,30589,31397,31697,32873,33909,33929,34672,36332,36917,38551,39304,39319,39745)then 'kui'
             when asicchz in (22256,22372,24707,25414,26118,28956,29736,37260,38175,38403,39649,40114)then 'kun'
             when asicchz in (24275,25193,25324,34526,38420)then 'kuo'
             when asicchz in (21068,21862,21895,22403,25289,26095,30220,30764,33098,34593,36771,37003)then 'la'
             when asicchz in (23811,24469,26469,28062,28625,30302,30544,31809,33713,36169,36182,38140)then 'lai'
             when asicchz in (20848,23146,23706,25042,25318,25597,26003,26639,27012,28389,28452,28572,28866,31726,32518,32625,34013,35124,35272,35888,38247,38417)then 'lan'
             when asicchz in (21879,24266,26391,27028,28010,29436,29701,31234,33943,34690,37070,38406)then 'lang'
             when asicchz in (20332,21171,21792,23013,23810,24521,25438,26675,28061,28889,29282,30184,32769,32802,37226,37290,38097,38137)then 'lao'
             when asicchz in (20048,20162,21202,21499,27856,40147)then 'le'
             when asicchz in (20769,22046,22418,23256,25794,27281,27882,30922,31867,32047,32551,32696,32786,32907,34174,35796,37241,38253,38647)then 'lei'
             when asicchz in (20919,22596,24867,26865,26974)then 'leng'
             when asicchz in (20029,20363,20432,20442,20458,20616,21033,21147,21169,21382,21385,21400,21519,21590,21737,21811,21937,22364,23052,23264,25150,26446,26533,26638,26647,26792,27813,28327,28435,28583,29313,29432,29441,29702,29827,30112,30124,30178,30778,30782,31036,31163,31435,31520,31717,31729,31890,31901,32545,32633,33190,33480,33620,33669,33673,34016,34268,34510,34570,34849,35400,36318,36729,36902,37094,37300,37324,38146,38582,38643,39562,40097,40100,40162,40514,40654,40679)then 'li'
             when asicchz in (20457)then 'lia'
             when asicchz in (22849,24088,24265,24604,24651,25947,26973,27539,28063,28491,28610,28860,29711,32451,32852,33080,33217,33714,34105,34826,35042,35043,36830,38142,38256,40098)then 'lian'
             when asicchz in (20004,20142,20510,20937,22682,26238,26753,26891,31918,31921,33391,33704,35845,36361,36742,37327,38162,38739,39753)then 'liang'
             when asicchz in (20102,20698,22073,23525,23534,23589,24278,25730,25769,26009,28518,29134,29536,30103,32557,32842,34044,36797,38028,38243,40553)then 'liao'
             when asicchz in (20925,21015,21155,21671,22482,25449,27916,28872,29454,35010,36244,36496,39715)then 'lie'
             when asicchz in (20020,20955,21533,21833,23961,24298,25044,25294,26519,27305,28107,29747,29848,30645,30967,31932,34106,36161,36495,36762,36980,37051,38678,40158,40607)then 'lin'
             when asicchz in (20196,20278,20940,21478,21604,22265,23725,26563,26818,27872,28789,29618,29940,32491,32666,32718,32838,33491,33777,34505,37187,38083,38517,38646,39046,40110,40836)then 'ling'
             when asicchz in (20845,21016,26066,26611,27060,27969,27983,28316,29080,29705,30041,30244,30827,32506,36955,37775,38157,38223,39311,39581,40552)then 'liu'
             when asicchz in (21679)then 'lo'
             when asicchz in (21657,22404,22405,25314,26634,27895,29649,30275,30779,31423,31548,32843,32999,33551,38471,38534,40857)then 'long'
             when asicchz in (21949,23044,23901,25602,27004,28431,30232,31699,32807,33932,34684,38210,38475,39621)then 'lou'
             when asicchz in (21346,21348,22108,22406,24208,24405,25134,25523,25784,26636,27257,27655,27896,28172,28425,28510,28809,29840,30860,31108,31759,33002,33339,33446,34383,36162,36335,36723,36738,36760,36911,38245,38470,38706,39045,40065,40072,40492,40557,40575,40595)then 'lu'
             when asicchz in (20081,21365,23048,23402,23782,25371,26686,28390,33044,37550,40510)then 'luan'
             when asicchz in (25504,30053,38154)then 'lue'
             when asicchz in (20177,20262,22261,25249,27814,32438,35770,36718)then 'lun'
             when asicchz in (20526,25694,26916,27898,27931,28463,29473,29662,30256,31657,32476,32599,33078,33638,33821,33853,34746,34819,35064,36923,38179,38233,38610,39558,39585)then 'luo'
             when asicchz in (20387,20603,21525,23649,23653,24459,25419,26053,27016,27695,28388,29575,31238,32511,32533,33154,34385,35099,38109,38398,39540)then 'lv'
             when asicchz in (21586)then 'm'
             when asicchz in (21527,21787,22043,22920,26473,29368,29595,30721,34434,34758,39532,39554,40635)then 'ma'
             when asicchz in (20080,21154,21334,22475,33033,33644,36808,38718,40614)then 'mai'
             when asicchz in (22657,23258,24148,24930,26364,28385,28459,29107,30610,32550,34067,34542,34728,35881,38232,38804,39071,39314,40151)then 'man'
             when asicchz in (24537,27667,28461,30450,30829,33426,33579,33725,34770,37017)then 'mang'
             when asicchz in (20882,21359,23745,24125,25035,26052,26164,27611,27862,29286,29483,29761,30592,30683,32772,33538,33541,33542,34661,34762,34980,35980,36152,38086,38170,39654)then 'mao'
             when asicchz in (20040,40637)then 'me'
             when asicchz in (22969,23186,23194,23504,23883,26151,26522,26757,26979,27599,27809,28028,28228,29028,29496,29611,30473,32654,33683,34946,37238,38209,38213,38665,39749,40539)then 'mei'
             when asicchz in (20204,25041,25194,28950,38036,38376,38391)then 'men'
             when asicchz in (21200,23391,25077,26406,26790,27308,29467,29965,30431,30626,31006,33355,33384,33804,33945,34427,34594,34835,38192)then 'meng'
             when asicchz in (21674,22055,23443,23494,24130,24357,24365,25929,27752,27852,29461,30511,31074,31192,31859,31964,32315,33042,33416,34588,35269,35868,35879,36855,37274,38753,40587)then 'mi'
             when asicchz in (20813,20885,21193,23081,26825,27796,28177,28238,30468,30496,32501,32517,33148,38754)then 'mian'
             when asicchz in (21941,22937,24217,25551,26474,28156,28218,30471,30596,31186,32520,32554,33495,34256,37000,40523)then 'miao'
             when asicchz in (20060,21673,28781,31742,34065,34843)then 'mie'
             when asicchz in (23735,24751,24845,25279,25935,26107,26108,27665,27887,29599,29641,30399,32535,33504,38389,38397,40152,40702)then 'min'
             when asicchz in (20901,21517,21629,26126,26269,27962,28319,30609,33559,34719,37225,38125,40483)then 'ming'
             when asicchz in (35884)then 'miu'
             when asicchz in (22696,23275,23351,23518,25273,25705,25720,25721,26411,27169,27521,27819,28448,30268,30952,31203,32817,33180,33545,33707,34022,34321,35871,35978,35992,38214,38476,39309,39764,40664)then 'mo'
             when asicchz in (20372,21726,26576,29279,30520,34513,35851,37738)then 'mou'
             when asicchz in (20137,20203,21215,22390,22675,22982,24149,24917,25287,26286,26408,27597,27626,27792,29281,29287,30446,30566,31302,33500,38076)then 'mu'
             when asicchz in (21584,21738,23068,25343,25466,32435,32941,34930,37027,38048,38222)then 'na'
             when asicchz in (20035,20340,22856,22902,26608,27670,32784,33407,33816,40720)then 'nai'
             when asicchz in (21335,21891,22237,22241,26976,30007,33129,34683,36199,38590)then 'nan'
             when asicchz in (22218,22228,25902,26345,39317)then 'nang'
             when asicchz in (21622,22452,23404,24700,25376,28118,29489,29785,30791,33041,34546,38105,38393)then 'nao'
             when asicchz in (21602,35767)then 'ne'
             when asicchz in (20869,39297)then 'nei'
             when asicchz in (23273,24641)then 'nen'
             when asicchz in (33021)then 'neng'
             when asicchz in (20274,20320,20522,21311,22381,22958,23612,24617,25311,26062,26165,27877,28346,29450,30568,33147,34364,36870,38092,38675,40117)then 'ni'
             when asicchz in (22493,24180,24319,24565,25288,25467,25781,30910,31896,34091,36743,40071,40118,40655)then 'nian'
             when asicchz in (23064,37247)then 'niang'
             when asicchz in (23346,23615,33074,33553,34949,40479)then 'niao'
             when asicchz in (20060,21870,21995,23421,25423,28037,32834,33260,34326,36433,38218,38221,38503,39070)then 'nie'
             when asicchz in (24744)then 'nin'
             when asicchz in (20318,20957,21659,23425,25319,26592,27870,29406,29999,32845)then 'ning'
             when asicchz in (22942,24568,25197,25303,29275,29379,32445,38062)then 'niu'
             when asicchz in (20396,20892,21725,24324,27987,33043)then 'nong'
             when asicchz in (32808)then 'nou'
             when asicchz in (21162,22900,23397,24361,24594,33004,39549)then 'nu'
             when asicchz in (26262)then 'nuan'
             when asicchz in (25386,30111,34384)then 'nue'
             when asicchz in (20649,21903,25062,25638,31983,35834,38168)then 'nuo'
             when asicchz in (22899,24679,34884,38037)then 'nv'
             when asicchz in (21734,22114)then 'o'
             when asicchz in (20598,21589,24580,27431,27572,27812,29935,32806,34261,35764,40485)then 'ou'
             when asicchz in (21866,24085,24597,25170,26487,29228,29750,31586,32793,33897,36276)then 'pa'
             when asicchz in (20467,21708,24472,25293,25490,27966,28227,29260,33934)then 'pai'
             when asicchz in (21028,21467,25306,25856,27886,28504,29247,30036,30424,30460,30928,34784,34978,35195,36434)then 'pan'
             when asicchz in (20051,22786,24222,24439,25909,26049,28354,30917,32810,32982,34691,36868)then 'pang'
             when asicchz in (21032,21263,21638,24214,25243,27873,28846,29389,30129,33068,34957,36305)then 'pao'
             when asicchz in (20329,21624,22521,24084,26054,27803,32986,35060,36180,36756,37197,37253,38187,38506,38664)then 'pei'
             when asicchz in (21943,28243,30406)then 'pen'
             when asicchz in (22061,22539,24429,24614,25256,25447,26379,26842,28558,28921,30768,30844,30896,31735,33192,34028,34779,40527)then 'peng'
             when asicchz in (19989,20211,20731,21128,21305,21542,21860,22140,22318,22383,22500,23218,23617,24192,25209,25259,25815,26503,27607,28128,29749,29971,30091,30130,30174,30294,30382,30738,32432,32628,33086,33432,34445,34609,34987,35692,35988,36767,37043,37099,38093,38516,38713,40729)then 'pi'
             when asicchz in (20415,20559,29255,29327,31687,32745,33020,35869,36417,39560,39575)then 'pian'
             when asicchz in (21117,22028,23254,27533,28418,29922,30623,31080,32549,33705,34741,39128)then 'piao'
             when asicchz in (20031,24417,25735,27669,30629,33508)then 'pie'
             when asicchz in (21697,23000,23252,25340,27008,29277,32856,36139,39057,39078)then 'pin'
             when asicchz in (20050,20444,20911,20973,22378,23049,23631,24179,26544,29942,33529,33805,35780,40070)then 'ping'
             when asicchz in (21493,22369,23110,27900,29632,30372,30772,31544,31893,36843,37169,38027,38071,39047,39748)then 'po'
             when asicchz in (21078,25482,35026)then 'pou'
             when asicchz in (20166,21261,22103,22275,22484,25169,26222,26292,26333,26420,27654,28006,28325,28654,28689,29854,33670,33769,33889,33970,35889,36476,38138,38244,38248)then 'pu'
             when asicchz in (19971,20062,20115,20225,20447,20854,20932,21551,22017,22120,22331,22855,22865,22971,23674,23682,23696,23822,24323,25001,25114,26071,26399,26462,26578,26646,26724,26827,27117,27450,27495,27668,27732,27773,27791,27875,28103,28422,29734,29738,30054,30732,30875,31041,31048,31098,32166,32494,32521,32774,33040,33425,33450,33793,33803,33914,34162,34548,34590,35755,36215,36804,39040,39568,39569,40141,40594,40784)then 'qi'
             when asicchz in (22841,24688,25488,27965,33884,34999,39618)then 'qia'
             when asicchz in (20094,20191,20325,20521,21069,21315,22545,23693,23884,24749,24838,24906,25190,25518,25652,26912,27424,27465,27973,28508,29301,31614,31645,32420,32561,32951,33418,33441,33564,33640,34388,35120,35878,35892,36801,36963,38030,38052,38065,38067,38085,38433,39582,40660)then 'qian'
             when asicchz in (21595,22681,23281,23558,24378,25109,25111,25250,26538,27183,28829,32652,32671,33108,34103,34595,35137,36292,38166,38197,38250)then 'qiang'
             when asicchz in (20052,20392,20431,21066,21121,22771,23780,23789,24039,24708,24832,24980,25772,25970,26725,27189,27207,30631,30807,31373,32562,32728,33630,35822,35887,36343,38201,38802,38808)then 'qiao'
             when asicchz in (19988,20999,22974,24623,24812,25352,31363,31655,33540,36228,37060,38194)then 'qie'
             when asicchz in (20146,20405,21220,21539,21994,22105,23517,25599,25810,27278,27777,28337,29748,30684,31165,31206,33449,33465,34707,34942,35203,38054,38163)then 'qin'
             when asicchz in (20542,21375,22282,24198,24773,25806,26228,27296,27682,27696,28165,30956,32174,32580,33496,34619,35622,35831,36731,38738,39031,40109,40677)then 'qing'
             when asicchz in (29756,31351,31353,31559,33557,34537,36331,37019,37518)then 'qiong'
             when asicchz in (19992,20421,22234,24047,27000,27714,27845,28267,29360,29699,31179,31959,34412,34479,34660,35032,36167,36881,36946,37041,37195,40133,40765)then 'qiu'
             when asicchz in (21164,21306,21435,21462,23094,23624,23702,26354,26384,27661,28192,29865,30319,30655,30962,31067,33507,34134,34343,34502,34512,34876,34914,35281,35790,36235,36259,36527,38418,39537,40498,40628,40674,40843)then 'qu'
             when asicchz in (20840,21048,21149,22280,24731,25331,26435,27849,29356,29357,30030,30154,31564,32507,33603,34615,35808,36737,37275,38120,39079,39688)then 'quan'
             when asicchz in (21364,24747,27063,28820,30264,30830,32570,38421,38425,38592,40522)then 'que'
             when asicchz in (32676,35033,36897,40583)then 'qun'
             when asicchz in (20873,26579,28982,29123,33490,34490,39663)then 'ran'
             when asicchz in (22199,22756,25880,29924,31155,31344,35753)then 'rang'
             when asicchz in (23046,25200,26721,32469,33627,39286)then 'rao'
             when asicchz in (21903,24825,28909)then 're'
             when asicchz in (20154,20161,20190,20219,20995,22764,22922,24525,31252,32427,33615,34941,35748,36715,38887,39274)then 'ren'
             when asicchz in (20173,25172)then 'reng'
             when asicchz in (26085)then 'ri'
             when asicchz in (20887,23481,23896,25102,27029,28342,29076,29416,32466,32924,33592,33635,33993,34686,34701)then 'rong'
             when asicchz in (25545,26580,31941,32905,36418,38819)then 'rou'
             when asicchz in (20083,20754,20837,22149,22914,23418,27741,27955,28349,28641,32539,33593,34000,34231,34837,35109,35174,36785,38135,39077)then 'ru'
             when asicchz in (26378,36719,38446)then 'ruan'
             when asicchz in (26520,29790,30591,33454,34122,34148,34443,38160)then 'rui'
             when asicchz in (28070,38384)then 'run'
             when asicchz in (20556,23164,24369,31660,33509)then 'ruo'
             when asicchz in (21317,25746,27922,33038,33832,39122)then 'sa'
             when asicchz in (22139,22622,33134,36187,40131)then 'sai'
             when asicchz in (19977,20200,20254,21441,24417,25955,27637,39315)then 'san'
             when asicchz in (20007,21971,25633,26705,30921,39073)then 'sang'
             when asicchz in (22525,23234,25195,25620,30233,32555,33226,39578,40139)then 'sao'
             when asicchz in (21868,28073,29791,31313,33394,38127)then 'se'
             when asicchz in (26862)then 'sen'
             when asicchz in (20711)then 'seng'
             when asicchz in (20667,21049,21414,21820,21861,26432,27459,27801,29022,30183,30722,32433,33678,35039,38121,38670,40104)then 'sha'
             when asicchz in (26194,31579,37246)then 'shai'
             when asicchz in (21024,21089,21892,22479,22999,23319,23665,25159,25797,26441,26629,27733,28536,29053,29642,30109,32558,33203,33211,33314,33439,33515,34798,34923,35754,36193,36314,37167,38032,38378,38485,39583,40157)then 'shan'
             when asicchz in (19978,20260,21830,22439,22674,23578,26188,27527,27895,29109,32497,35059,35294,36175)then 'shang'
             when asicchz in (21165,21242,21736,23569,25422,26451,26786,28530,28903,31245,31602,32461,33348,33421,33493,34552,37045,38808,38902)then 'shao'
             when asicchz in (20312,21389,22882,23556,24913,25586,25668,27481,28041,28384,29470,30066,31038,33292,33293,34503,35774,36170,36198,40605)then 'she'
             when asicchz in (20280,21442,21627,21698,23072,23158,23457,24910,26937,27784,28145,28182,28183,29637,29978,30003,30695,30775,31070,31937,32453,32958,32962,33688,33882,34563,35804,35842,36523)then 'shen'
             when asicchz in (20056,21097,21319,22307,22768,23882,26119,26207,28177,28262,29298,29983,29989,30427,30465,30490,31513,32499,32988)then 'sheng'
             when asicchz in (19990,20107,20160,20181,20351,20365,21183,21273,21313,21490,21980,22040,22124,22488,22763,22833,22987,23454,23460,23608,23630,24066,24072,24335,24337,24643,25325,25342,26045,26102,26159,26623,27663,28287,28859,29422,30690,30707,31034,31035,31598,33296,33715,33997,34417,34432,34731,35270,35475,35782,35797,35799,35877,35925,36147,36732,36866,36893,37322,38088,39135,39280,39542,40101,40122)then 'shi'
             when asicchz in (20861,21463,21806,23432,23551,25163,25480,25910,29417,30246,32502,33359,39318)then 'shou'
             when asicchz in (20008,20070,20446,20495,21460,22654,22661,23005,23408,23646,24246,24661,25101,25234,25669,25968,26257,26329,26415,26463,26530,26641,26803,27530,27571,27641,27821,28113,28465,28557,29087,30095,31211,31446,32446,32626,33127,33298,33789,34092,34223,34560,36174,36755,36848,40653,40736)then 'shu'
             when asicchz in (21047,21808,32781)then 'shua'
             when asicchz in (24069,25684,29575,29993,34752,34928)then 'shuai'
             when asicchz in (25332,26643,28078,38377)then 'shuan'
             when asicchz in (21452,23360,29245,38684)then 'shuang'
             when asicchz in (27700,30561,31246,35841)then 'shui'
             when asicchz in (21550,30636,33308,39034)then 'shun'
             when asicchz in (22913,25632,26388,27082,28865,30805,33972,35828,38084)then 'shuo'
             when asicchz in (19997,20282,20284,20447,20821,21422,21430,21496,21661,21987,22070,22235,22994,23546,24051,24605,25749,26031,27515,27740,27863,28556,31040,31169,31525,32524,32796,32902,34547,38198,39282,39543,40502)then 'si'
             when asicchz in (20935,23435,23847,23913,24554,24578,24730,26494,28126,31462,32824,33752,35772,35829,36865,39042)then 'song'
             when asicchz in (21471,21974,22013,22014,25628,25822,28338,30605,33368,34222,34699,38204,39125,39306)then 'sou'
             when asicchz in (20439,20723,21961,22609,22809,23487,24875,28049,28335,29990,31267,31756,31903,32032,32899,33487,34060,35307,35785,35873,36895,37221)then 'su'
             when asicchz in (29435,31639,33948,37240)then 'suan'
             when asicchz in (23681,28617,29159,30509,30562,30862,31071,31319,32485,33661,34429,35847,36930,36995,38539,38543,38567,39635)then 'sui'
             when asicchz in (23385,25439,27051,29426,31499,33642,38588,39143)then 'sun'
             when asicchz in (21766,21794,21965,21990,23057,25152,25394,26731,26797,29712,30531,32034,32553,32679,34001,38145)then 'suo'
             when asicchz in (20182,21970,22604,22612,22905,23427,25374,27067,27795,28347,28463,29549,36287,36367,36427,36962,38090,38396,40142)then 'ta'
             when asicchz in (21488,22823,22826,24577,25260,27760,27888,28849,32957,32974,33492,34233,36294,37040,37214,38043,39552,40080)then 'tai'
             when asicchz in (21497,22349,22363,22374,24377,24528,25506,25674,26137,27264,27631,28393,28525,28601,28845,30192,30251,30899,34962,35203,35848,35885,36138,37103,38077,38188)then 'tan'
             when asicchz in (20504,20645,21776,22530,22616,24081,24797,25642,26848,27160,27748,28108,28303,28907,29805,31958,32688,32805,33179,34711,34739,36255,36538,37283,38132,38231)then 'tang'
             when asicchz in (21480,21845,22871,25487,26691,27950,28059,28120,28372,32486,33796,35752,36867,38518,38892,39253,40727)then 'tao'
             when asicchz in (24529,24530,24925,29305,38141)then 'te'
             when asicchz in (28373,30140,33150,34276,35466)then 'teng'
             when asicchz in (20307,20508,21059,21076,21884,22159,23198,23625,24716,24789,25552,26367,26799,28053,32488,32519,33617,35068,36386,36420,36886,37261,38161,39064,40520)then 'ti'
             when asicchz in (22635,22825,24541,24684,25517,27524,28155,28233,29980,30000,30027,33094,33300,38423)then 'tian'
             when asicchz in (20347,25361,26465,30522,31079,31381,31524,31900,33493,34601,35843,36339,36834,39659,40102,40838)then 'tiao'
             when asicchz in (24086,33820,36148,38081,39214)then 'tie'
             when asicchz in (20141,20572,21381,21548,23159,24237,24311,25402,26755,27712,28867,29693,33351,33691,33910,34579,38116,38662)then 'ting'
             when asicchz in (20189,20319,21516,22005,24420,24696,25413,26704,26742,28540,30171,30643,30780,31461,31570,32479,33596,36890,37230,38108)then 'tong'
             when asicchz in (20599,22836,25237,36879,39600)then 'tou'
             when asicchz in (20820,20984,21520,22270,22303,22541,23648,24466,28034,31171,31361,33660,33759,36884,37236,38029)then 'tu'
             when asicchz in (22242,24406,25247,28237,30083)then 'tuan'
             when asicchz in (25512,29050,33151,34581,35114,36864,39059)then 'tui'
             when asicchz in (21534,22244,23663,26302,27709,33216,35930,39272)then 'tun'
             when asicchz in (20039,20311,21822,22376,22949,24249,25176,25299,25302,26561,26589,26925,27216,27825,30755,31656,33073,36302,37217,38464,39534,39548,40501,40717)then 'tuo'
             when asicchz in (20324,21703,23043,23090,25366,27964,29926,33149,34521,34972)then 'wa'
             when asicchz in (22806,23860,27498)then 'wai'
             when asicchz in (19975,20024,21084,23113,23436,23451,24367,24779,25405,26202,28286,28919,29609,29740,30073,30358,30871,32424,32510,33048,33109,33412,33694,33728,34067,34623,35916,39037)then 'wan'
             when asicchz in (20129,22916,24448,24536,24792,26106,26395,26505,27754,29579,32593,32596,36747,39757)then 'wang'
             when asicchz in (20026,20255,20266,20301,20558,21355,21361,21619,21807,21890,22260,22313,22996,23041,23059,23561,23614,23916,24013,24079,24119,24494,24799,24944,26410,26693,27817,27943,28064,28205,28493,28828,29032,29477,29484,29614,30031,30207,32428,32500,32963,33353,33479,33806,33907,34074,34183,35839,35859,36558,36829,36918,38385,38536,38551,38886,38890,39759,40084)then 'wei'
             when asicchz in (21006,21563,22786,25909,25991,27766,28201,29882,30239,31283,32010,32441,34442,38382,38395,38412,38639)then 'wen'
             when asicchz in (21985,29934,32705,33994,34169)then 'weng'
             when asicchz in (20525,21351,21908,24132,25105,25373,25569,26017,27779,28065,28197,30826,31389,32927,33716,34583,40844)then 'wo'
             when asicchz in (20044,20116,20213,20237,20398,20800,21153,21247,21320,21556,21566,21596,21780,22316,22366,22953,23162,23524,23627,24043,24209,24548,24579,24694,24735,25098,25410,26080,26212,26444,26791,27494,27595,27745,28944,29289,29310,30182,33310,33436,33460,34568,35820,35823,36821,37036,37576,38056,38434,38654,39579,40521,40540,40751)then 'wu'
             when asicchz in (20064,20694,20846,21560,21775,21916,22075,22805,22874,23219,23305,23651,24076,24109,24473,24687,24713,24796,25103,26132,26224,26342,26512,26646,27176,27268,27447,27481,27728,27927,28000,28101,28330,28911,29060,29081,29113,29306,29312,29626,30361,30717,30802,31114,31143,31232,31352,31902,31995,32454,32690,32725,33181,33284,33342,33564,33765,33912,34032,34597,34693,34763,34989,35068,35199,35275,36426,37079,37295,38115,38177,38411,38553,38576,39273,40759)then 'xi'
             when asicchz in (19979,20384,21283,21414,21523,21623,22799,23777,26247,26585,29390,29421,29781,30606,30806,32581,34430,36758,36944,38686,40672)then 'xia'
             when asicchz in (20185,20808,20924,21439,21688,23092,23244,23466,23704,24358,25472,26174,26297,27673,28046,29177,29443,29486,29616,29625,30187,31046,31557,31868,32420,32447,32673,33146,33335,33483,33718,34259,34476,34900,35265,36132,36323,36345,37232,38184,38386,38480,38505,38519,38704,39301,40092,40519)then 'xian'
             when asicchz in (20065,20139,20687,21410,21521,21709,24055,24224,24819,27233,28248,30456,31077,31665,32515,32724,33431,33881,34771,35140,35814,35937,38262,38477,39033,39144,39287,39321,39591,40094)then 'xiang'
             when asicchz in (21066,21715,21742,21880,22179,23389,23477,23567,23844,25928,26195,26541,26549,26657,28040,28102,28487,30813,31505,31601,31659,32481,32918,33831,34552,36877,38144,38660,39553,39752)then 'xiao'
             when asicchz in (20123,20149,20565,20889,21232,21327,21368,23633,24296,25032,25375,25658,25783,26012,26800,26964,27021,27053,27463,27844,27899,28203,28707,29166,29548,32449,32556,32961,34212,34638,34809,35856,35874,36416,36510,36994,37034,38795,39049)then 'xie'
             when asicchz in (20449,22239,24515,24571,26032,26133,27427,27462,33455,33688,34218,34885,36763,37995,38156,38241,39336)then 'xin'
             when asicchz in (20852,21009,22411,22995,24184,24418,24615,24763,24826,25828,26143,26447,27920,29481,30465,30798,33125,33607,33637,34892,37026,37266,38473,39271)then 'xing'
             when asicchz in (20804,20982,21256,27769,29066,33016,33422,38596)then 'xiong'
             when asicchz in (20241,20462,21691,21957,23723,24229,26429,28340,31168,32483,32670,33261,34966,35973,38152,39312,39673,40506)then 'xiu'
             when asicchz in (21206,21465,21505,22040,22313,22687,22977,23167,24207,24464,24676,25100,26093,26665,27947,28294,29030,30044,30449,31944,32110,32490,32493,32951,32997,33988,34047,34394,35768,35817,37207,37265,38656,39035,39036)then 'xu'
             when asicchz in (20743,21927,23459,24748,25550,26059,26244,26982,27883,28210,28457,28843,28892,29002,29572,29764,29831,30147,30307,30505,30905,32474,33841,35862,36713,36873,38089,38239)then 'xuan'
             when asicchz in (22129,23398,27894,31348,34203,34880,35857,36357,38634,38772,40149)then 'xue'
             when asicchz in (21195,21235,22489,23547,23755,24033,24061,24455,24490,24642,26092,26331,27529,27739,27957,27988,27994,29071,29551,31400,33600,33640,34120,34224,35757,35759,35810,36805,36874,37063,37306,39535,40095)then 'xun'
             when asicchz in (20011,20122,20258,21387,21568,21713,22445,23045,23688,23830,25276,25568,26720,27689,28079,29273,29706,30166,30554,30737,33469,34460,34905,35766,36711,36819,38597,40486,40493)then 'ya'
             when asicchz in (20005,20456,20547,20822,21089,21388,21411,21693,21761,22479,22576,22852,22925,23267,23359,23476,23721,23846,24310,24422,24697,25513,26191,26858,27280,27839,28153,28270,28383,28436,28814,28895,28937,28976,28977,29141,29744,30416,30524,30740,30746,31605,32616,33005,33100,33395,33784,34578,34893,35328,35866,35891,36189,36284,37118,37154,37245,38379,38409,38414,38415,38593,39068,39181,39564,39751,40761)then 'yan'
             when asicchz in (20208,20335,20859,22830,24457,24591,24665,25196,26104,26472,26679,27523,27687,27889,27915,28478,28800,28874,30113,30162,31207,32650,34520,38451,38789,40495)then 'yang'
             when asicchz in (21510,21676,22426,22829,22934,23002,23591,23870,24186,24493,25671,26332,26483,29243,29671,29814,31368,31377,32768,32948,33136,33280,33647,35201,35875,36730,36965,36992,38123,40144,40542,40637)then 'yao'
             when asicchz in (19994,20063,20918,21494,22094,22812,25341,25494,25586,25590,26196,26355,26928,28082,28904,29239,32822,33099,35858,37050,37326,38104,38757,39029)then 'ye'
             when asicchz in (19968,20041,20057,20134,20159,20197,20202,20234,20314,20350,20381,20506,21000,21139,21307,21587,21670,21695,21964,22123,22319,22520,22777,22839,22869,23016,23452,23673,23748,23991,24050,24322,24328,24331,24413,24441,24518,24609,24639,24722,24847,25087,25233,25401,25558,26070,26131,26885,27449,27562,27589,27778,28005,28322,28458,29088,29463,30097,30123,30157,30231,30292,30410,30489,30691,31227,32462,32546,32703,32714,32716,32755,32764,32900,33008,33222,33315,33402,33406,33505,33617,34191,34433,34503,34612,34915,35028,35758,35793,35794,35811,35850,36155,36726,36836,36920,36951,37009,37199,38023,38129,38226,38257,39056,39284,39551,40671)then 'yi'
             when asicchz in (21360,21535,21554,21905,22240,22432,22553,22820,23035,23493,23609,24341,27575,27684,27911,28139,29434,30270,31400,32996,33562,33589,33643,34451,37150,38111,38134,38452,38544,38698,38899,39278,40840)then 'yin'
             when asicchz in (22052,23156,23221,23348,24212,24433,25732,26144,27001,27185,28386,28486,28699,29787,29838,30271,30408,30828,32552,32578,33210,33521,33556,33637,33639,33721,33722,33828,33829,33830,34021,34631,36194,36814,37090,39053,39062,40550,40560)then 'ying'
             when asicchz in (21727,21815)then 'yo'
             when asicchz in (20323,20433,21191,21647,21889,22665,22725,24248,24703,24949,25317,27704,27891,28044,29992,29996,30152,33219,34553,36362,37013,38235,38605,39252,40153)then 'yong'
             when asicchz in (20248,20305,20369,21347,21448,21451,21491,21606,22271,23461,23586,23588,24188,24189,24551,24736,25912,26377,26586,27833,28216,29270,29369,29495,30001,30115,32327,33692,33696,33720,34480,34484,34659,34660,35825,37038,37193,37321,38080,38101,40063,40669,40748)then 'you'
             when asicchz in (19982,20104,20110,20251,20313,20446,20451,21505,21947,22276,22281,22495,22948,22954,23089,23431,23507,23561,23679,23786,23899,24254,24423,24481,24840,24841,24858,25540,26044,26161,27014,27428,27442,27603,28020,28132,28180,28189,29020,29152,29425,29427,29577,29760,29788,30066,30208,30224,30402,31161,31162,31404,31411,31485,31909,32417,32701,32895,32946,33140,33278,33281,33286,33419,33848,34019,34398,34606,34643,35029,35278,35465,35821,35840,35861,35947,36802,36926,36935,37057,38064,38408,38533,38632,38633,39044,39275,39296,39533,39739,40060,40518,40556,40841)then 'yu'
             when asicchz in (20803,20900,21407,21592,22253,22278,22300,22435,22456,22636,23195,24616,24895,25534,25588,27260,27781,28170,28304,29232,29503,29783,30498,31650,32536,33451,33489,34696,34945,36757,36828,38498,40482,40499,40715)then 'yuan'
             when asicchz in (20048,21014,21717,23731,24742,26352,26376,26638,27198,28729,29605,31908,32422,35828,36234,36291,38053,38074,38405,40864)then 'yue'
             when asicchz in (20113,20801,21248,23381,24701,24864,26112,26197,27538,27698,29096,29377,31584,32429,32792,33464,34164,36103,36191,36816,37075,37095,37213,37574,38504,38642,38891,38901)then 'yun'
             when asicchz in (21277,21634,25334,26434,30776)then 'za'
             when asicchz in (20877,21705,22312,23472,23869,26685,28798,30014,36733)then 'zai'
             when asicchz in (21681,25874,26141,26242,29906,31786,31948,36190,36273,37694)then 'zan'
             when asicchz in (22872,33039,33255,33900,36163,39541)then 'zang'
             when asicchz in (20991,21795,22122,26089,26531,28577,28790,29157,30338,31967,34299,34468,36481,36896,36973)then 'zao'
             when asicchz in (20164,21017,21863,24123,25321,26115,27901,31654,33332,36131,36188,36846)then 'ze'
             when asicchz in (36156)then 'zei'
             when asicchz in (24590,35886)then 'zen'
             when asicchz in (22686,24974,26366,29111,29969,32559,32638,36192,38147)then 'zeng'
             when asicchz in (20045,21522,21643,21668,21747,21939,25166,25592,26413,26629,26946,27048,28195,28856,30148,30504,30751,34481,35784,36711,38113,38392,40772)then 'zha'
             when asicchz in (20538,23429,23528,25688,25995,30261,30758,31364,32735)then 'zhai'
             when asicchz in (21344,23637,23853,25112,25612,26025,26051,26632,27617,27838,28251,30415,30651,31449,31896,32509,34360,35449,35893,36759)then 'zhan'
             when asicchz in (19976,20169,20183,23260,23938,24080,24155,24352,24432,25484,26454,27167,28072,28467,29520,29835,30260,31456,32960,34769,36134,37155,38271,38556)then 'zhang'
             when asicchz in (20806,21484,25214,25307,26157,26397,26873,27836,29031,31498,32617,32903,35791,36213,38026)then 'zhao'
             when asicchz in (20039,21746,21894,25240,25722,26584,27993,30932,32773,34071,34544,34567,34731,35126,35882,36205,36740,36761,36825,36974,38167,40551)then 'zhe'
             when asicchz in (20390,22323,24103,25391,26015,26389,26517,26722,26937,27035,27976,29645,29956,30043,30137,30495,30759,31087,31289,31668,32540,32983,33275,33985,35786,36126,36168,36728,38024,38215,38453,38663,40489)then 'zhen'
             when asicchz in (20105,23781,24449,24501,24596,25327,25379,25919,25972,27491,29424,30151,30529,31581,33976,35777,35812,37073,38066,38126)then 'zheng'
             when asicchz in (20043,20356,20540,21046,21358,21482,21553,21675,22336,22516,23769,24089,24092,24408,24535,24558,25191,25351,25370,25527,25709,25903,26088,26234,26525,26547,26624,26633,26702,26893,27490,27542,27713,27835,28382,28825,30164,30179,30452,30693,31049,31209,31258,31378,32119,32440,32455,32622,32844,32930,32989,33026,33187,33267,33268,33437,33463,34541,34584,35311,35960,36136,36157,36286,36310,36396,36399,36725,36734,37061,37231,38495,38601,39576,40503,40697)then 'zhi'
             when asicchz in (20013,20210,20247,20898,24544,24554,30405,31181,32456,32959,33327,34749,34935,36405,37325,38047,38202)then 'zhong'
             when asicchz in (21608,21650,21825,22959,23449,24030,24090,26172,27954,30385,30881,31808,31909,32327,32419,32457,32920,32964,33311,33646,35788,36724,37198,39588)then 'zhou'
             when asicchz in (20027,20267,20303,20367,21161,22065,23646,25284,26417,26492,26609,26666,27104,27237,27880,27929,28186,28532,28855,28891,29038,29482,29664,30128,30211,30633,31069,31481,31482,31569,31672,32741,33331,33486,33585,33879,34496,34523,35803,35832,36142,36485,36880,37054,38114,38136,39547,40584)then 'zhu'
             when asicchz in (25235,25373,29226)then 'zhua'
             when asicchz in (25341)then 'zhuai'
             when asicchz in (19987,20256,21869,25776,30742,31686,36186,36716,39067,39316)then 'zhuan'
             when asicchz in (20718,22766,22918,24162,24196,25758,26729,29366,35013)then 'zhuang'
             when asicchz in (22368,24820,26894,32512,32530,33809,36184,36861,38181,38585,39571)then 'zhui'
             when asicchz in (20934,23663,31360,32939,35846)then 'zhun'
             when asicchz in (20524,21331,21828,25305,25417,25826,26027,26700,27978,27998,28095,28655,28796,29730,30528,31130,33537,35836,37196,38255)then 'zhuo'
             when asicchz in (20180,20857,21618,21672,22986,23039,23376,23383,23388,23411,23915,24675,26771,28100,28173,28363,28371,30502,31213,31531,31869,31906,32043,32513,32788,33258,33544,35390,35864,36160,36164,36241,36750,38193,39661,40123,40839)then 'zi'
             when asicchz in (20588,23447,24635,26837,31933,32437,32508,33113,36394,39683)then 'zong'
             when asicchz in (22863,25549,35833,36208,37049,37177,38508,39546,40112)then 'zou'
             when asicchz in (20430,21330,26063,31062,31199,32452,33785,35781,36275,38238,38459)then 'zu'
             when asicchz in (25893,32386,32565,36508,38075)then 'zuan'
             when asicchz in (22068,26368,32618,34142,35292,37257)then 'zui'
             when asicchz in (23562,25753,27197,36981,40159)then 'zun'
             when asicchz in (20304,20316,20570,21777,22060,22352,24038,24231,24589,26152,26590,31066,31534,32985,37218,38460)then 'zuo'
        end
        retval
        from asclb
           
    )
    select
      string_agg(retval,'') into sresult
      from hzpdlb;

  return sresult;

end;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100
来做第一个评论吧!~

发送评论 编辑评论


				
|´・ω・)ノ
ヾ(≧∇≦*)ゝ
(☆ω☆)
(╯‵□′)╯︵┴─┴
 ̄﹃ ̄
(/ω\)
∠( ᐛ 」∠)_
(๑•̀ㅁ•́ฅ)
→_→
୧(๑•̀⌄•́๑)૭
٩(ˊᗜˋ*)و
(ノ°ο°)ノ
(´இ皿இ`)
⌇●﹏●⌇
(ฅ´ω`ฅ)
(╯°A°)╯︵○○○
φ( ̄∇ ̄o)
ヾ(´・ ・`。)ノ"
( ง ᵒ̌皿ᵒ̌)ง⁼³₌₃
(ó﹏ò。)
Σ(っ °Д °;)っ
( ,,´・ω・)ノ"(´っω・`。)
╮(╯▽╰)╭
o(*////▽////*)q
>﹏<
( ๑´•ω•) "(ㆆᴗㆆ)
😂
😀
😅
😊
🙂
🙃
😌
😍
😘
😜
😝
😏
😒
🙄
😳
😡
😔
😫
😱
😭
💩
👻
🙌
🖕
👍
👫
👬
👭
🌚
🌝
🙈
💊
😶
🙏
🍦
🍉
😣
Source: github.com/k4yt3x/flowerhd
颜文字
Emoji
小恐龙
花!
上一篇
下一篇