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 vote349 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote363 views1 answer
Soql update query
SQL
0 vote351 views1 answer
How to declare variable date in mysql
SQL
0 vote335 views1 answer
Restart sql server command line linux
SQL
0 vote303 views1 answer
Connection error in mysql workbench
SQL
0 vote327 views1 answer
Select from another database
SQL
0 vote376 views1 answer
Recently updated stored procedure in sql server
SQL
15 votes345 views1 answer
Mysql int range
SQL
-1 vote344 views5 answers
Online sql to linq generator
SQL
0 vote386 views1 answer
"Hello User Name"
SQL