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 vote299 views1 answer
Sqlite update only if greater
SQL
2 votes332 views1 answer
Oracle block
SQL
1 vote347 views1 answer
Postgresql if 0 then 1
SQL
0 vote321 views1 answer
Sqlite get date only
SQL
0 vote300 views1 answer
Sqlalchemy sequence postgresql
SQL
0 vote292 views1 answer
Sql auto_increment syntax
SQL
0 vote318 views1 answer
Change filed order in mysql
SQL
5 votes332 views4 answers
Traduction
SQL
1 vote332 views1 answer
Altrer name column postgres
SQL
24 votes311 views6 answers
Rename a column in sql server
SQL