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

8 votes215 views2 answers
Python simple connect to mysql
SQL
13 votes163 views5 answers
Select last row mysql
SQL
0 vote178 views1 answer
Sql update subtract value
SQL
0 vote126 views1 answer
Procedures and functions in pl/sql
SQL
2 votes328 views5 answers
Unique in sql server
SQL
0 vote166 views1 answer
Get duplicate entry sql
SQL
1 vote152 views1 answer
Nested if in mysql
SQL
3 votes182 views2 answers
See mysql users ubuntu
SQL
3 votes161 views2 answers
Sql server current date without time
SQL
0 vote177 views1 answer
Select even number id data from table
SQL