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) 收藏 举报
                    
                
                
            
        
浙公网安备 33010602011771号