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 vote156 views1 answer
How to access to mysql without root
SQL
0 vote145 views1 answer
Check psql validity function
SQL
4 votes138 views3 answers
Sql drop database if exists
SQL
0 vote150 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
-1 vote155 views1 answer
Phinehas Psalm 106
SQL
-1 vote158 views2 answers
Installing mysql on centos 7
SQL
0 vote166 views1 answer
Postgresql cast as year and month from timestamp
SQL
0 vote163 views1 answer
Sql server create constraint
SQL
1 vote137 views1 answer
How to get mysql db size
SQL
1 vote160 views1 answer
PL SQL MODIFY COLUMN NME
SQL