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 vote186 views1 answer
How to import sqlite driver class in java using maven
SQL
5 votes211 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
1 vote197 views1 answer
Select from one table where not on the other
SQL
0 vote207 views1 answer
Select last 2 characters sql
SQL
1 vote197 views6 answers
In sql
SQL
0 vote207 views1 answer
Postgres truncate with cascade
SQL
0 vote194 views1 answer
Mysql page segment
SQL
0 vote216 views1 answer
Uncheck constraints and delete from table
SQL
0 vote234 views1 answer
Java sql timestamp now
SQL
0 vote235 views1 answer
Hue hive UploadingTextFiletoHive
SQL