Postgresql:动态sql的例子

1. CREATEorReplaceFUNCTIONfunc_getnextid(
2. tablenamevarchar(240),
3. idnamevarchar(20)default'id')
4. RETURNSintegerAS$funcbody$
5. Declare
6. sqlstringvarchar(240);
7. currentIdinteger;
8. Begin
9. sqlstring:='selectmax("'||idname||'")from"'||tablename||'";';
10. EXECUTEsqlstringintocurrentId;
11. ifcurrentIdisNULLorcurrentId=0then
12. return1;
13. else
14. returncurrentId+1;
15. endif;
16. End;
17. $funcbody$LANGUAGEplpgsql;

21. CREATE OR REPLACE FUNCTION test_get_sql(IN sql character varying,OUT io_cursor_ref refcursor)
    RETURNS record AS
    $BODY$
    DECLARE
    BEGIN
    OPEN IO_CURSOR_REF FOR
    execute sql;

    RETURN; END; $BODY$ LANGUAGE plpgsql VOLATILE COST 100; ALTER FUNCTION test_get_sql(character varying)

（编辑：李大同）

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