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

4 votes166 views1 answer
What are the data types in sql
SQL
6 votes174 views1 answer
To count number of rows in SQL table
SQL
3 votes197 views3 answers
Raw select laravel
SQL
0 vote173 views1 answer
Sql select by content lenght
SQL
0 vote184 views1 answer
Edit shchima table in sql
SQL
0 vote174 views3 answers
Convert sql query to python pandas
SQL
1 vote176 views1 answer
Oracle list data files
SQL
0 vote172 views1 answer
How to change null display in psql
SQL
0 vote186 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote168 views1 answer
Luu ckeditor vao mysql
SQL