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

Reply via email to