In PostgreSql 8.1 i've tried to use parameter but when I've changed
function (added parameter)
CREATE R REPLACE FUNCTIN reffunc3(FRM_ID in integer,****_RW UT
integer) RETURNS SETF Person AS '
DECLARE
rec RECRD;
BEGIN
SELECT count(*) INT ****_RW FRM Person WHERE ssn>FRM_ID ;
FR rec IN SELECT ssn,name FRM Person WHERE ssn>FRM_ID
LP
c;RETURN NEXT rec ;
END LP ;
RETURN ;
END;
' LANGUAGE plpgsql;
* from reffunc3(1) ;
i've seen :
ERRR: function result type must be integer because of UT parameters
course when I change parameter to Integer it must be Record error
appears.
What should I change, and how to call this function?
Mirek
(end of broadcast)
TIP 5: don't forget to increase your free space map settings