Re: Stored Procedure Problem - Mailing list pgsql-sql

Atul wrote:

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

First: select into an_integer,an_name emp_id,emp_name...
Second: you can't return 2 variables from plpgsql function.

Tomasz Myrta