想要实现如下的功能
CREATE OR REPLACE FUNCTION sel_firm_manage(character)
RETURNS SETOF firm_manage AS
$BODY$
DECLARE
r firm_manage%rowtype;
BEGIN
FOR r IN SELECT * FROM firm_manage
WHERE status='0'AND
-------------------------------
--想要把 $1 当作条件的项目, --
--不知有没有人知道?? --
-------------------------------
$1 = '001' ?? LOOP
-- can do some processing here
RETURN NEXT r; -- return current row of SELECT
END LOOP;
RETURN ;
END
$BODY$
LANGUAGE 'plpgsql';希望大侠们帮忙!!
CREATE OR REPLACE FUNCTION sel_firm_manage(character)
RETURNS SETOF firm_manage AS
$BODY$
DECLARE
r firm_manage%rowtype;
BEGIN
FOR r IN SELECT * FROM firm_manage
WHERE status='0'AND
-------------------------------
--想要把 $1 当作条件的项目, --
--不知有没有人知道?? --
-------------------------------
$1 = '001' ?? LOOP
-- can do some processing here
RETURN NEXT r; -- return current row of SELECT
END LOOP;
RETURN ;
END
$BODY$
LANGUAGE 'plpgsql';希望大侠们帮忙!!
你式一下不就知道了。