PostgreSQL 获取拼音首字母的函数 （可以获取所有中文字符）经典原创分享

CREATE OR REPLACE FUNCTION "gis"."get_hzpycap"("v_str" varchar, "needhz" int4=0)

  RETURNS "pg_catalog"."varchar" AS $BODY$

DECLARE

  pos        INT4;

  hzlen      INT4;

  hz         VARCHAR (10);

  hzbm       INT4;

  hzpy       VARCHAR (10);

  py         VARCHAR (4000);

  hasspace   INT4;

   hzpybm_0 = 'xxx';

   hzpybm_1 = 'xxx';

   hzpybm_2 = 'xxx';

   ... 具体见附件

BEGIN

  hzlen = NVL (LENGTH (v_str), 0);

  hasspace = 0;