That worked.

However, perhaps I don't understand the idea of a function.

If the , in this case ('1'), was in fact an unknown variable what would the return be?

Bob
----- Original Message ----- From: "John R Pierce" <pie...@hogranch.com>
To: "Bob Pawley" <rjpaw...@shaw.ca>; <pgsql-general@postgresql.org>
Sent: Friday, 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; to the end of the function with no success.



I'd try adding
    RETURN 1;  or similar,  before the END;




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to