postgresql - Plpgsql:如何在声明部分为变量赋值？

Question

例如。

--Assigning value to variable in function as a parameter.
create or replace function f1(number int :=1) --This method is not working to me. 

或

--Assigning values to variables at declaration section.
declare
       number int :=1; -- Here i need to assign the value to number but its not working.
       name varchar :='xyz'; 

Answer 1

这里是你如何做到的:

create or replace function f1(my_number int default 1)

或

declare
my_number int :=1;

看declaration documentation