Re: Stored Procedure Problem - Mailing list pgsql-sql

From Christoph Haller
Subject Re: Stored Procedure Problem
Date
Msg-id 3DF8911D.DAFAEF09@rodos.fzk.de
Whole thread Raw
In response to Stored Procedure Problem  ("Atul" <atul@imcindia.net>)
List pgsql-sql
> CREATE FUNCTION b_function() RETURNS int4 AS '
> DECLARE
>    an_integer int4;
> BEGIN
>    select emp_id from employee;
>    return an_integer;
> END;
> '
> LANGUAGE 'plpgsql';
>
Try
SELECT INTO an_integer emp_id from employee;

Regards, Christoph



pgsql-sql by date:

Previous
From: "Atul"
Date:
Subject: Stored Procedure Problem
Next
From: Héctor Iturre
Date:
Subject: Re: Stored Procedure Problem