Re: calling a plpgsql procedure

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: s <smarie(at)ekno(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: calling a plpgsql procedure
Date: 2002-06-25 00:28:10
Message-ID: 20020624172606.W61359-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 24 Jun 2002, s wrote:

> Sorry to post such a stupid question. I have read the "create
> function" documentation and searched old mailing lists, but I can't
> seem to find an example of how to call a plpgsql procedure that isn't
> associated with a trigger.

In general the easiest way is to use it in a select:
select func(args);
(assuming your function isn't defined to return opaque)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-06-25 00:31:39 Re: SQL server application porting headache
Previous Message Stephan Szabo 2002-06-25 00:25:43 Re: Help with Arrays and References