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 vote468 views1 answer
Sql insert exemplo
SQL
10 votes331 views4 answers
How to alter table name in mysql
SQL
0 vote331 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
0 vote323 views1 answer
Sqlite update only if greater
SQL
0 vote320 views1 answer
Postgresql select fast check no rows
SQL
0 vote334 views1 answer
Mysql locate
SQL
0 vote315 views1 answer
Oracle job schedules
SQL
2 votes319 views2 answers
Get all columns from table sql
SQL
1 vote333 views1 answer
Hexadec to sql REDSHIFT
SQL
1 vote368 views1 answer
Floor function in sql oracle
SQL