Re: type bug?

On Tuesday, October 5, 2021, <ml(at)ft-c(dot)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.