Re: Stored Procedure Problem - Mailing list pgsql-sql

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…