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 vote153 views1 answer
Nueva tabla mysql
SQL
24 votes148 views4 answers
How to add column sql
SQL
1 vote152 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote155 views1 answer
Mysql date time string format python
SQL
0 vote144 views1 answer
Select value from previous row in postgresql
SQL
1 vote183 views1 answer
Postgresql float 2 decimal places
SQL
3 votes159 views1 answer
Get current month last date in sql server
SQL
2 votes171 views1 answer
Import large .sql files into lampp
SQL
1 vote154 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
0 vote153 views1 answer
Suse start MySQL
SQL