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

1 vote206 views3 answers
Read all columns of a table sql
SQL
0 vote236 views1 answer
Delete a temporary table mysql
SQL
3 votes212 views1 answer
Postgres select max value
SQL
3 votes268 views1 answer
Query less than datetime sql
SQL
0 vote209 views1 answer
Mysql date format unix timestamp
SQL
2 votes263 views1 answer
Match in sql server
SQL
1 vote210 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
0 vote167 views1 answer
Copy table dbeaver
SQL
2 votes210 views1 answer
Oracle convert run_duration to number
SQL
0 vote208 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL