Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics - Mailing list pgsql-general

Alexey Dokuchaev <danfe@nsu.ru> 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