我创建了一个类似这样的过程:
但是它抛出以下错误:
错误:函数insert_user_ax_register(unknown, unknown, unknown, timestamp with time zone, unknown, unknown, timestamp with time zone, unknown, unknown, unknown, bigint)不存在 SQL状态:42883 提示:没有函数与给定的名称和参数类型匹配。您可能需要添加显式类型转换。 字符: 16
请帮我解决这个问题。我对pgsql不熟悉,无法从Google中找到任何解决方案。我正在使用
CREATE OR REPLACE FUNCTION insert_user_ax_register(
user_name character varying(50),
password character varying(300),
role_id character varying(10),
created_dt date,
status boolean,
email character varying(50),
join_date character varying(30),
phone_no bigint,
client_address character varying(200),
full_name character varying(100),
financial_year character varying(10))
RETURNS void
AS $BODY$
declare
begin
INSERT INTO ax_register(user_name,password,role_id,created_dt,status,email,join_date,phone_no,client_address,full_name,financial_year)
VALUES (user_name,password,role_id,now(),true,email,join_date,phone_no,client_address,full_name,financial_year);
end
$BODY$
LANGUAGE plpgsql VOLATILE
我尝试这样执行它:
SELECT * from insert_user_ax_register('debasrita','debasrita','client001',now(),'t','abc@gmail.com',now(),'ctc','debasrita','2014-15',9090909090);
但是它抛出以下错误:
错误:函数insert_user_ax_register(unknown, unknown, unknown, timestamp with time zone, unknown, unknown, timestamp with time zone, unknown, unknown, unknown, bigint)不存在 SQL状态:42883 提示:没有函数与给定的名称和参数类型匹配。您可能需要添加显式类型转换。 字符: 16
请帮我解决这个问题。我对pgsql不熟悉,无法从Google中找到任何解决方案。我正在使用
pgsql 9.1.3
请问我实现目标的正确方法是什么?