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

1 vote446 views1 answer
Sql and
SQL
0 vote364 views1 answer
Order by with where clause in mysql
SQL
0 vote350 views1 answer
Minus equivalent in my sql
SQL
0 vote342 views1 answer
Oracle right characters
SQL
10 votes355 views1 answer
Oracle object dependencies
SQL
0 vote345 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote387 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
0 vote328 views1 answer
Default column value in sql same as other column
SQL
2 votes376 views1 answer
Cast string to datetime mysql
SQL
0 vote353 views1 answer
Initcap in sql
SQL