The following bug has been logged on the website:
Bug reference: 11094
Logged by: Henart
Email address: henart@sofisticat.com.br
PostgreSQL version: 9.3.4
Operating system: CentOS 6.5
Description:
drop type if exists tp_testes cascade;
create type tp_testes as ( tipo integer);
create or replace function fnc_testes() returns tp_testes as
$$
declare
t tp_testes;
x integer;
begin
t.tipo = 1;
x = t.valor ;
return t;
end;
$$
language plpgsql;
the above script does not report error when compiling the function, but
"t.valor" does not exists in type.
if i use
t.valor = 1;
error occurs when compiling the function. in earlier versions (such as 8.4),
SQL STATE 42703 error occurs.
Tks