Thread: how to execute a function directly

how to execute a function directly

From
Paul Tilles
Date:
Is there any way to execute a postgresql function directly?  In
Informix, there is an

EXECUTE PROCEDURE proc_name();

statement which will execute a Stored Procedure directly.

In postgresql, I can

SELECT  function_name();

or

DELETE fucntion_name();

both of which will cause the function to be executed.

I was wondering if there is a more generic way to cause a function to be
executed.

Paul Tilles



Re: how to execute a function directly

From
Bruno Wolff III
Date:
On Wed, Jun 30, 2004 at 09:04:13 -0400, Paul Tilles <Paul.Tilles@noaa.gov> wrote:
> 
> I was wondering if there is a more generic way to cause a function to be
> executed.

I think you should consider using SELECT as the generic way to call functions
in Postgres.