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

3 votes145 views3 answers
Restart mysql mac
SQL
0 vote150 views1 answer
How much space does sql server take per row
SQL
2 votes123 views1 answer
Drop all database tables oracle sql developer
SQL
5 votes132 views1 answer
Get column name sql server
SQL
0 vote121 views1 answer
Create a table from one field of another table
SQL
0 vote118 views2 answers
Sql count number of rows after group by
SQL
0 vote129 views1 answer
Sql where part of string match
SQL
0 vote134 views1 answer
How to use lower case in mysql
SQL
1 vote127 views1 answer
Drop function
SQL
1 vote133 views1 answer
Check if mysql is installed
SQL