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 vote137 views1 answer
Table or view does not exist
SQL
1 vote159 views1 answer
How to run parallel queries in sql server with entity framework
SQL
0 vote165 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote150 views1 answer
Hour and minute between two datatime sql
SQL
0 vote154 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
25 votes153 views4 answers
Sqlserver add column
SQL
8 votes159 views10 answers
Sql
SQL
0 vote164 views1 answer
Update database collation in postgresql
SQL
20 votes136 views1 answer
Get all table name in sql through php
SQL
0 vote142 views1 answer
Contact mysql column field
SQL