Re: [SQL] Stored Procedure Problem

[Tomasz Myrta]

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


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]