Plpgsql:如何在声明部分为变量赋值? [英] Plpgsql: How can i assign value to variable at declaration section?

问题描述

例如.

--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'; 

推荐答案

以下是您的操作方法:

create or replace function f1(my_number int default 1)

或

declare
my_number int :=1;

查看声明文档

这篇关于Plpgsql:如何在声明部分为变量赋值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！