: Bob Pawley
Cc: John R Pierce ; pgsql-general@postgresql.org
Sent: Friday, June 26, 2009 10:30 AM
Subject: Re: [GENERAL] Need help using function
On Fri, Jun 26, 2009 at 1:28 PM, Bob Pawley wrote:
However, perhaps I don't understand the idea of a function.
Please review the
On Fri, Jun 26, 2009 at 1:28 PM, Bob Pawley wrote:
> However, perhaps I don't understand the idea of a function.
Please review the manual for examples.
http://www.postgresql.org/docs/8.3/static/plpgsql.html
Specifically,
http://www.postgresql.org/docs/8.3/static/plpgsql-structure.html
--
Jo
June 26, 2009 10:15 AM
Subject: Re: [GENERAL] Need help using function
Bob Pawley wrote:
Hi
I want to try using functions but I am having trouble understanding
return.
...
The error message - "control reached end of function without RETURN"
I have attempted adding - Return integer
Bob Pawley wrote:
Hi
I want to try using functions but I am having trouble understanding
return.
...
The error message - "control reached end of function without RETURN"
I have attempted adding - Return integer; to the end of the function
with no success.
I'd try adding
RETURN
Hi
I want to try using functions but I am having trouble understanding return.
This is the function -
CREATE OR REPLACE FUNCTION p_id.ip_orient_3()
RETURNS integer AS
$BODY$
Begin
Insert into fluids (fluid_id) values ('1') ;
End;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
ALTER
