匿名块

 

 

declare
sales number(10, 2);

text1 text := 'hello world';
a number := 2;

begin

raise info '% ', text1;
raise info '% ', a;
raise info 'text1';

end;

declare
b number := a;
~

 

raise的时候需要用%

 

 https://www.postgresql.org/docs/9.3/plpgsql-errors-and-messages.html