Message-ID: <40E2BA4D.18C25CC0@noaa.gov>
Date: Wed, 30 Jun 2004 09:04:13 -0400
From: Paul Tilles <Paul.Tilles@noaa.gov>
Organization: DOC/NOAA/NWS - National Weather Service
MIME-Version: 1.0
To: interfaces <pgsql-interfaces@postgresql.org>
Subject: how to execute a function directly
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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