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 vote140 views1 answer
Postgresql create query
SQL
12 votes124 views4 answers
Mysql get date difference in hours
SQL
0 vote134 views4 answers
Sql server date format yyyy-mm-dd
SQL
0 vote177 views1 answer
Sql server is not
SQL
0 vote101 views2 answers
Delete the last item in a table sql
SQL
0 vote134 views2 answers
Sql server select where date
SQL
1 vote128 views1 answer
Postgresql convert text to float
SQL
0 vote138 views1 answer
Oracle get running queries
SQL
20 votes148 views4 answers
Sql count if
SQL
17 votes141 views3 answers
Postgresql version command
SQL