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 vote97 views1 answer
Select mysql limit to 2 decimal places
SQL
0 vote168 views1 answer
Get enginge db mysql
SQL
0 vote151 views1 answer
Select insert new table sql server
SQL
3 votes140 views3 answers
C# sql select
SQL
4 votes126 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote132 views1 answer
Timestamp(0) postgresql
SQL
0 vote143 views1 answer
Postgres in operator with comma separated values
SQL
0 vote158 views1 answer
Sql server current time without date
SQL
11 votes173 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
3 votes155 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL