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 vote261 views2 answers
Mysql on update current_timestamp
SQL
2 votes256 views1 answer
Postgresql transaction
SQL
0 vote267 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote244 views1 answer
Use between operator in mysql
SQL
2 votes243 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote266 views1 answer
Logtash mysql cofiguration file
SQL
0 vote269 views1 answer
Alter column to not null with default value sql server
SQL
2 votes301 views3 answers
How to replace null values in sql
SQL
0 vote261 views1 answer
Postgresql check total storage
SQL
0 vote261 views1 answer
Mysql select where field like in list
SQL