postgresql存储过程需要返回多个数据项,怎么解决?
REATE OR REPLACE FUNCTION abc( a NUMERIC, b NUMERIC, c NUMERIC, OUT high NUMERIC, OUT low NUMERIC) AS $$ BEGIN high := GREATEST(a,b,c); low := LEAST(a,b,c); END; $$ 复制
REATE OR REPLACE FUNCTION abc( a NUMERIC, b NUMERIC, c NUMERIC, OUT high NUMERIC, OUT low NUMERIC) AS $$ BEGIN high := GREATEST(a,b,c); low := LEAST(a,b,c); END; $$
使用变量接受出参