po 15. 4. 2019 v 18:07 odesÃlatel Tom Lane napsal:
> Pavel Stehule writes:
> > 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' i
Pavel Stehule writes:
> 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;
> $$
You can
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
