Skip site navigation (1) Skip section navigation (2)

how to execute a function directly

From: Paul Tilles <Paul(dot)Tilles(at)noaa(dot)gov>
To: interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: how to execute a function directly
Date: 2004-06-30 13:04:13
Message-ID: 40E2BA4D.18C25CC0@noaa.gov (view raw or flat)
Thread:
Lists: pgsql-interfaces
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


Responses

pgsql-interfaces by date

Next:From: apellido jr., wilfredo p.Date: 2004-06-30 13:26:06
Subject: help !!!
Previous:From: Lee KindnessDate: 2004-06-30 11:30:36
Subject: Embedded SQL timestamp Question (ECPG)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group