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 votes161 views3 answers
Sql set
SQL
0 vote156 views1 answer
Sql remove last 2 digit
SQL
2 votes154 views1 answer
Q operator in oracle
SQL
0 vote147 views1 answer
Mysql begin statement
SQL
2 votes110 views1 answer
Oracle current date without time
SQL
1 vote301 views3 answers
Create table from existing table in sql
SQL
1 vote151 views2 answers
Oracle replace
SQL
0 vote152 views1 answer
How to install mysql without admin rights
SQL
9 votes201 views3 answers
Pyodbc connect to sql server
SQL
0 vote156 views1 answer
Rename view mysql
SQL