On Wed, 2021-10-06 at 00:21 -0500, Ron wrote:
>
> What version of Postgresql do you think has the bug?
> Where did you get the Postgresql binaries from?
> What platform?
FreeBSD
pkg install postgresql ...
Version 13.3
a friend use Debian unstable with PG version 14 and have the same
problem.
>
> On 10/5/21 10:50 PM, ml@ft-c.de wrote:
> > Hello,
> >
> > there is a bug with types in functions. Here is an example:
> >
> > --drop type xyz;
> > create type xyz as ( x numeric, y numeric, z numeric );
> >
> > --drop table test_xyz ;
> > create table test_xyz ( a int, b xyz, c xyz );
> > insert into test_xyz values
> > ( 1,(11.1, 12.3, 14.5 ), (22.2, 22.3, 24.5 ) ) ;
> >
> > --drop function test_xyz() ;
> > create function test_xyz() returns table ( a xyz, b xyz) as
> > $$
> > select b, c from test_xyz ;
> > $$ language sql ;
> >
> > --drop function test_xyz2() ;
> > create function test_xyz2() returns table ( b xyz) as
> > $$
> > select b from test_xyz ;
> > $$ language sql ;
> >
> > --drop function test_xyz3() ;
> > 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_xyz() ;
> > select * from test_xyz2() ; -- 3 columns, but 1 should be correct?
> > select b from test_xyz2() ; -- error
> > select x from test_xyz2() ; -- never declared column
> > select * from test_xyz3() ; -- compiling error
> > -- ------
> >
> > (I am not a member of the pg-developer mailinglist. )
> >
> > Franz
> >
> >
> >
>