CREATE OR REPLACE FUNCTION pg.regexp_substr(text, text)
RETURNS text
LANGUAGE sql
IMMUTABLE STRICT
AS
f
u
n
c
t
i
o
n
function
function
select unnest(regexp_matches($1,$2))
f
u
n
c
t
i
o
n
function
function
;
– 使用
replace(regexp_substr(reqbackremark,‘二级原因:[^; ]*’),‘二级原因:’,‘’)二级原因