pg的function的编写

发布时间：2020-12-13 17:05:13 所属栏目：百科来源：网络整理

导读：语法 CREATE OR REPLACE FUNCTION public.em_quick_query( IN userid character varying,IN orgid character varying) RETURNS TABLE(id bigint,parent_id bigint) AS$BODY$BEGIN RETURN QUERY EXECUTE 'select id,parent_id from ... where xx = ' || id ||

语法

CREATE OR REPLACE FUNCTION public.em_quick_query(
    IN userid character varying,IN orgid character varying)
  RETURNS TABLE(id bigint,parent_id bigint) AS
$BODY$
BEGIN
    RETURN QUERY EXECUTE 
    'select id,parent_id from ... where xx = ' || id || ' and ...' ;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100
  ROWS 1000;
ALTER FUNCTION public.em_quick_query(character varying,character varying)
  OWNER TO myuser;

调用

select * from em_quick_query(201,10)

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!