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 vote223 views1 answer
Replace \n sql
SQL
0 vote181 views1 answer
Mysql read row
SQL
2 votes128 views1 answer
Sql select in list
SQL
0 vote175 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
1 vote197 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote189 views1 answer
Mysql master slave setup with keepalived
SQL
-1 vote187 views1 answer
Condition in orderby mysql
SQL
3 votes270 views1 answer
How to get yesterday date in sql
SQL
0 vote194 views1 answer
MySQL error code 2068
SQL
0 vote206 views1 answer
Mysql utc timestamp
SQL