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

3 votes201 views1 answer
Show index table
SQL
2 votes212 views1 answer
Mysql create user with mysql_native_password
SQL
1 vote195 views1 answer
Mysql date diff in seconds
SQL
6 votes245 views1 answer
Postgresql get year
SQL
2 votes219 views1 answer
Sql server current date minus 5 years
SQL
0 vote265 views1 answer
Postgres extract number from string
SQL
14 votes189 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
2 votes217 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote242 views1 answer
Oracle sql date winter time
SQL
0 vote196 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL