如何在Postgresql中产生自己的集合function
CREATE FUNCTION join_two_with_comma(text, text) RETURNS text
LANGUAGE sql
AS $_$
SELECT CASE
WHEN $2 IS NULL OR $2 = '' THEN $1
WHEN $1 IS NULL OR $1 = '' THEN $2
ELSE $1 || ', ' || $2
END
$_$;
CREATE AGGREGATE join_with_comma(text) (
SFUNC = join_two_with_comma,
STYPE = text,
INITCOND = ''
);
LANGUAGE sql
AS $_$
SELECT CASE
WHEN $2 IS NULL OR $2 = '' THEN $1
WHEN $1 IS NULL OR $1 = '' THEN $2
ELSE $1 || ', ' || $2
END
$_$;
CREATE AGGREGATE join_with_comma(text) (
SFUNC = join_two_with_comma,
STYPE = text,
INITCOND = ''
);
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,携手博客园推出1Panel与Halo联合会员
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步