pgsql thinkphp5_TP5使用pgsql报错“没有匹配指定名称和参数类型的函数.您也许需要增加明确的类型转换”的解决办法......

CREATE OR REPLACE FUNCTION pgsql_type(a_type varchar) RETURNS varchar AS$BODY$DECLAREv_typevarchar;BEGIN

IF a_type='int8' THENv_type:='bigint';

ELSIF a_type='int4' THENv_type:='integer';

ELSIF a_type='int2' THENv_type:='smallint';

ELSIF a_type='bpchar' THENv_type:='char';ELSEv_type:=a_type;END IF;RETURNv_type;END;

$BODY$

LANGUAGE PLPGSQL;CREATE TYPE "public"."tablestruct" AS(

"fields_key_name"varchar(100),

"fields_name"VARCHAR(200),

"fields_type"VARCHAR(20),

"fields_length"BIGINT,

"fields_not_null"VARCHAR(10),

"fields_default"VARCHAR(500),

"fields_comment"VARCHAR(1000)

);CREATE OR REPLACE FUNCTION "public"."table_msg" (a_schema_name varchar, a