pgsql 自定义函数

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

 

posted on 2022-11-01 08:56  emisunshine  阅读(269)  评论(0)    收藏  举报