Hi
Is there reason why following code should not to work?
do $$
declare r record; result int;
begin
select 10 as a, 20 as b into r;
raise notice 'a: %', r.a;
execute 'select $1.a + $1.b' into result using r;
raise notice '%', result;
end;
$$
but it fails
NOTICE: a: 10
ERROR: could not identify column "a" in record data type
LINE 1: select $1.a + $1.b
^
QUERY: select $1.a + $1.b
CONTEXT: PL/pgSQL function inline_code_block line 6 at EXECUTE
Regards
Pavel