看来我没把问题说清楚 我做了一个用户函数如下 CREATE OR REPLACE FUNCTION sle_goods_schedule( text,character,character) RETURNS SETOF goods_schedule AS $BODY$ DECLARE r goods_schedule%rowtype; BEGIN FOR r IN EXECUTE ' SELECT * FROM goods_schedule WHERE '||$1||' order by '||$2||' '||$3 LOOP RETURN NEXT r; END LOOP; RETURN ; END $BODY$ LANGUAGE 'plpgsql'; 当我调用 select * from sle_goods_schedule("firm_id='ID00100000'",'reserve_id','ASC'); 的时候就报错,请问如何解决???
太恶了,select * from sle_goods_schedule('firm_id=\'ID00100000\'','reserve_id','ASC');即可
我做了一个用户函数如下
CREATE OR REPLACE FUNCTION sle_goods_schedule( text,character,character)
RETURNS SETOF goods_schedule AS
$BODY$
DECLARE
r goods_schedule%rowtype;
BEGIN
FOR r IN EXECUTE '
SELECT * FROM goods_schedule WHERE '||$1||' order by '||$2||' '||$3
LOOP
RETURN NEXT r;
END LOOP;
RETURN ;
END
$BODY$
LANGUAGE 'plpgsql';
当我调用
select * from sle_goods_schedule("firm_id='ID00100000'",'reserve_id','ASC');
的时候就报错,请问如何解决???