Re: Stored Procedure Problem

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