Re: [SQL] Stored Procedure Problem

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…

Reply via email to