You wrote a table-producing function (one row but three columns). Those need [1] to be executed in the FROM clause, via an implicit or explicit LATERAL join if you have data from other relations being fed in as input arguments.
David J.
1. well, at least if you don't want to see this kind of artifact where the way to expand .* is to copy the expression preceding it.
Do you mean select (out3).* .. equal to select (out3).col1, (out3).col3, (out3).col3 … ?
Didn`t even suppose that..
Sometimes I've used (row).col or (row).* in select list.
Would be appreciated if you could provide keywords for googling.
And yeah, after hours of confusion rewrote it to:
select o.*
from
(select jsonb_agg(t) as jsonbagg from tmp_view t) j
, lateral public.out3(j.jsonbagg) o;
And it works just fine!
