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

pl/pgsql declare variable

Terrible Tarsier answered on June 30, 2021 Popularity 3/10 Helpfulness 2/10

answer pl/pgsql declare variable

pl/pgsql declare variable

Comment

do $$ 
declare
   counter    integer := 1;
   first_name varchar(50) := 'John';
   last_name  varchar(50) := 'Doe';
   payment    numeric(11,2) := 20.5;
begin 
   raise notice '% % % has been paid % USD', 
       counter, 
	   first_name, 
	   last_name, 
	   payment;
end $$;

Popularity 3/10 Helpfulness 2/10 Language sql

Source: www.postgresqltutorial.com

Tags: declare sql

Link to this answer
Share Copy Link