Alexey Dokuchaev <danfe@xxxxxx> writes: > On Mon, May 21, 2018 at 10:45:27AM -0400, Tom Lane wrote: >> OP could do something like >> select json_agg(_) as j, count(*) as c INTO r FROM ( > Thanks, I've arrived at the same solution (using local RECORD) eventually. > It works as intended, but I still need to assign OUT parameters by hand: > retcode := tmp.c; > result := tmp.j; Actually, it should work to do select json_agg(_), count(*) INTO result, retcode FROM ... regards, tom lane
