Stored Procedure Problem - Mailing list pgsql-sql

Hello,

                Atul Here, I have one problem while accessing Database Records Or Recordset from stored procedure. Procedure is like this,

CREATE FUNCTION b_function() RETURNS int4 AS '

DECLARE

   an_integer int4;

BEGIN

   select emp_id from employee;

   return an_integer;

END;

'

LANGUAGE 'plpgsql';

I create the procedure . After that I run the statement like

Test=#> select b_function();

Error comes like

Error: ERROR:  SELECT query has no destination for result data.

                If you want to discard the results, use PERFORM instead.

WARNING:  Error occurred while executing PL/pgSQL function b_function

WARNING:  line 4 at SQL statement

Also I use PERFORM statement. But still problem is not resolved.

Please Help me. I hope your kind co-operation.

Thanks.

Atul…