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 vote109 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote126 views1 answer
Sql server information_schema temp tables
SQL
2 votes112 views1 answer
Sql find not in list
SQL
0 vote111 views1 answer
Cast float mysql
SQL
0 vote119 views1 answer
Docker open terminal mysql server
SQL
1 vote58 views1 answer
Alter user mysql native password
SQL
0 vote103 views1 answer
Java sql timestamp now
SQL
0 vote102 views1 answer
Add multiple field in table sql
SQL
7 votes124 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote100 views1 answer
Oracle last user logon
SQL