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