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 vote307 views1 answer
T-SQL Create Trigger
SQL
5 votes281 views1 answer
Update sql user password
SQL
-3 votes386 views8 answers
Sql to c# linq converter online
SQL
0 vote308 views1 answer
Change filed order in mysql
SQL
0 vote289 views1 answer
Sqlite closes value
SQL
0 vote278 views2 answers
Which MySQL statement is used to delete data from a database
SQL
0 vote299 views1 answer
Oracle job session
SQL
0 vote288 views1 answer
Oracle sql generate list of days
SQL
2 votes285 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote376 views1 answer
How to check common records in 2 table
SQL