Hi all,
I have written a sample procedure where i pass 2 arguments. Based on the
arguments i need to select few fields from a table. After selecting the
fields i have to display them. How do i return the selected fields. The
procedure is as follows
CREATE FUNCTION PP_ReadParameter(integer,varchar) RETURNS TEXT AS '
DECLARE
ParamId INTEGER;
ParamName TEXT;
IsFixEnum BIT;
IsExpandEnum BIT;
BEGIN
IF $1 IS NOT NULL THEN
SELECT INTO ParamId,ParamName,IsFixEnum,IsExpandEnum
AttributeId,AttributeName,IsFixEnum,IsExpandEnum
FROM Attributes
WHERE AttributeId = $1
ORDER BY AttributeId;
RETURN ''$1 successfull'';
END IF;
......
......
END;
' LANGUAGE 'plpgsql';
So when i say SELECT PP_ReadParameter(50,Null)......it should return the
ParamId,ParamName,....
But to check the working of the function i just return ''$1 successfull'' as
i dont know how to return the tuple.
Please help me on this
> With Best Regards
> Pradeep Kumar P J
>