Hi,
How to return multiple columns through stored procedure.
Consider EX.
CREATE FUNCTION b_function() RETURNS varchar AS '
DECLARE
an_integer int4;
an_name varchar;
BEGIN
select into an_integer emp_id,an_name emp_name from employee;
return an_integer,an_name;
END;
'
LANGUAGE 'plpgsql';
But This Gives Error(For Multiple column , not for single column)
Please Let me know.
Thanks
Atul