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 vote321 views1 answer
Oracle merge insert if not exists
SQL
0 vote345 views1 answer
Enable sql server full text indexing
SQL
1 vote338 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
2 votes356 views2 answers
Postgres timestamp to datetime
SQL
0 vote313 views1 answer
Oracle select invalid views
SQL
1 vote376 views1 answer
Find size of all DB's postgres
SQL
0 vote345 views1 answer
View to table sql
SQL
0 vote310 views1 answer
Oracle list chain steps
SQL
6 votes279 views2 answers
Generate c# class from sql server table
SQL
4 votes313 views1 answer
Mysql biginteger size
SQL