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

7 votes236 views2 answers
Sql empty table
SQL
0 vote139 views1 answer
Mysql query to add hours to column in table
SQL
3 votes130 views1 answer
Uppercase and lowercase in sql
SQL
9 votes134 views2 answers
Sql server check table exists
SQL
1 vote159 views1 answer
Mysql select all and rename one
SQL
0 vote142 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote137 views1 answer
Postgres - Login and connect as default user
SQL
38 votes215 views6 answers
Ubuntu install mysql client
SQL
-1 vote139 views1 answer
Sql syntax create timestamp column
SQL
-1 vote148 views1 answer
Default username and password for oracle 11g
SQL