On Tuesday, October 5, 2021, <
ml@ft-c.de> wrote:
create function test_xyz3() returns table ( b xyz) as
$$
declare
bb xyz;
cc xyz;
begin
select b, c into bb, cc from test_xyz ;
return bb ;
end;
$$ language plpgsql ;
-- ------
select * from test_xyz3() ; -- compiling error
Help others help you by writing out exact error messages (many of us can answer from just reading code and error messages without needing be able to execute said code ourselves). I suspect “table test_xyz not found” due to the typo.
David J.