CREATE OR REPLACE FUNCTION test1(id INTEGER,id1 INTEGER)
RETURNS INTEGER
LANGUAGE plpgsql
AS
$$
declare
count integer;
begin
count = (select array_position(string,'hehe19') from public.sal_emp1 where name = 'Bill31');
raise notice 'this is raise demo , param1 is %',count;
return count;
end;
$$
pgsql 自定义函数
最新推荐文章于 2024-06-12 11:13:48 发布