Breaking News: Grepper is joining You.com. Read the official announcement!

access outer loop variable in subblock plpgsql

Clumsy Chimpanzee answered on November 12, 2022 Popularity 1/10 Helpfulness 8/10

answer access outer loop variable in subblock plpgsql

access outer loop variable in subblock plpgsql

Comment

do $$ 
<<outer_block>>
declare
  counter integer := 0;
begin
   counter := counter + 1;
   raise notice 'The current value of the counter is %', counter;

   declare
       counter integer := 0;
   begin
       counter := counter + 10;
       raise notice 'Counter in the subblock is %', counter;
       raise notice 'Counter in the outer block is %', outer_block.counter;
   end;

   raise notice 'Counter in the outer block is %', counter;
   
end outer_block $$;
Code language: PostgreSQL SQL dialect and PL/pgSQL (pgsql)

Popularity 1/10 Helpfulness 8/10 Language sql

Source: www.postgresqltutorial.com

Tags: block plpgsql sql

Link to this answer
Share Copy Link