pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

how to execute a function directly
2+ messages / 2 participants
[nested] [flat]

* how to execute a function directly
@ 2004-06-30 13:04  Paul Tilles <Paul.Tilles@noaa.gov>
  0 siblings, 1 reply; 2+ messages in thread

From: Paul Tilles @ 2004-06-30 13:04 UTC (permalink / raw)
  To: 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: how to execute a function directly
@ 2004-06-30 13:54  Bruno Wolff III <bruno@wolff.to>
  parent: Paul Tilles <Paul.Tilles@noaa.gov>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruno Wolff III @ 2004-06-30 13:54 UTC (permalink / raw)
  To: Paul Tilles <Paul.Tilles@noaa.gov>; +Cc: pgsql-interfaces

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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2004-06-30 13:54 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-30 13:04 how to execute a function directly Paul Tilles <Paul.Tilles@noaa.gov>
2004-06-30 13:54 ` Bruno Wolff III <bruno@wolff.to>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox