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

5 votes259 views1 answer
Oracle asynchronous procedure
SQL
9 votes279 views1 answer
Mysql check date range
SQL
3 votes279 views1 answer
Stpop start psql server
SQL
7 votes284 views1 answer
Xampp reset mysql
SQL
0 vote292 views1 answer
Check if a column is a primary key in sql server
SQL
1 vote291 views1 answer
How to fetch alternate records from two tables
SQL
0 vote275 views1 answer
Create bdd mysql
SQL
1 vote273 views1 answer
Oracle avg
SQL
2 votes292 views1 answer
Oracle to_char number format percentage
SQL
0 vote295 views1 answer
How to print sql query
SQL