Re: How to call a stored procedure in PostgreSQL

Joost Kraaijeveld wrote:
> Hi all,
>
> How do I call a stored procedure in PostgreSQL? I tried "call procedure-name (arg 1, arg2)" but that does not seem to work...

select procedure(arg1,arg2)

or

select * from procedure(arg1,arg2)

depending on the type.

Sincerely,

Joshua D. Drake

>
> Groeten,
>
> Joost Kraaijeveld
> Askesis B.V.
> Molukkenstraat 14
> 6524NB Nijmegen
> tel: 024-3888063 / 06-51855277
> fax: 024-3608416
> e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
> web: www.askesis.nl
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
Command Prompt, Inc., your source for PostgreSQL replication,
professional support, programming, managed services, shared
and dedicated hosting. Home of the Open Source Projects plPHP,
plPerlNG, pgManage, and pgPHPtoolkit.
Contact us now at: +1-503-667-4564 - http://www.commandprompt.com