自定义函数实现单词排序并运用于PostgreSQL(实现代码)

drugs.split(separator)

drug_list.sort()

separator.join(drug_list)

def 单词排序(drugs,separator):

     if drugs:

         drug_list = drugs.split(separator)

         drug_list.sort()

         new_drugs = separator.join(drug_list)

     else :

         new_drugs = None

     return new_drugs

单词排序(drugs,separator)

DROP FUNCTION IF EXISTS 单词排序;

CREATE OR REPLACE FUNCTION 单词排序(drugs TEXT, separator TEXT)

     RETURNS text

AS $$

if drugs:

     drug_list = drugs.split(separator)

     drug_list.sort()

     new_drugs = separator.join(drug_list)

else :

     new_drugs = None

return new_drugs

$$ LANGUAGE plpython3u;

SELECT 单词排序( 'aa;dd;bbb;cd;zz' , ';' );