> 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
>