postgresql record 使用
<div class="postbody">今天在做postgresql 存储过程的时候，遇到了一个问题，找了好多资料没有解决，最后经过思考终于解决了
创建一个存储过程
<div style="border-right: #cccccc 1px solid; padding-right: 5px; border-top: #cccccc 1px solid; padding-left: 4px; font-size: 13px; padding-bottom: 4px; border-left: #cccccc 1px solid; width: 98%; padding-top: 4px; border-bottom: #cccccc 1px solid; background-color: #eeeeee;">http://www.agoit.com/Images/OutliningIndicators/None.gifCREATE OR REPLACE FUNCTION test(OUT name character varying, OUT _cur refcursor )
http://www.agoit.com/Images/OutliningIndicators/None.gifRETURNS record AS
http://www.agoit.com/Images/OutliningIndicators/None.gif$BODY$
http://www.agoit.com/Images/OutliningIndicators/None.gifDECLARE
http://www.agoit.com/Images/OutliningIndicators/None.gif _geom geometry;
http://www.agoit.com/Images/OutliningIndicators/None.gifBEGIN
http://www.agoit.com/Images/OutliningIndicators/None.gifname = '11';
http://www.agoit.com/Images/OutliningIndicators/None.gifopen _curfor SELECT id,name FROM test_tab;
http://www.agoit.com/Images/OutliningIndicators/None.gif--id ='222';
http://www.agoit.com/Images/OutliningIndicators/None.gifEND;
http://www.agoit.com/Images/OutliningIndicators/None.gif$BODY$
http://www.agoit.com/Images/OutliningIndicators/None.gifLANGUAGE 'plpgsql' VOLATILE
http://www.agoit.com/Images/OutliningIndicators/None.gifCOST 100;
http://www.agoit.com/Images/OutliningIndicators/None.gifALTER FUNCTION test() OWNER TO pg;
页:
[1]