Thread: need help on stored procedures

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
>