Pl/pgsql declare variable

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 $$;

Source: postgresqltutorial.com

Similar codes

0 vote225 views1 answer
Update top 100 order by sql server
SQL
0 vote233 views1 answer
How to write if case in select query in select statement
SQL
0 vote230 views1 answer
Sql convert float to string
SQL
0 vote233 views1 answer
How to login to mysql in homestead
SQL
0 vote233 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote224 views1 answer
Mysql use password error
SQL
1 vote234 views1 answer
Get count by weekly pivot table sql server
SQL
12 votes241 views5 answers
Rename table in mysql
SQL
0 vote221 views1 answer
Plpgsql if statement
SQL
4 votes305 views2 answers
Delete all table oracle
SQL