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@xxxxxxx 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 > > > > > > >
