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 vote260 views1 answer
Windows services sql
SQL
1 vote267 views2 answers
Postgres cast as decimal
SQL
0 vote288 views1 answer
Oracle current date minus 1 day
SQL
1 vote264 views1 answer
Ora-01950 no privileges on tablespace
SQL
11 votes325 views2 answers
Import mysql dump command line windows
SQL
0 vote276 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote303 views1 answer
Alternative for LIMIT sql
SQL
0 vote283 views1 answer
Providername system.data. mysql
SQL
0 vote270 views1 answer
Pgsql is not permitted to log in
SQL
4 votes244 views1 answer
Postgresql show current database
SQL