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

Re: How to call a stored procedure in PostgreSQL

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
Cc: "Pgsql-Odbc (E-mail)" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: How to call a stored procedure in PostgreSQL
Date: 2005-01-20 19:30:42
Message-ID: 41F006E2.5010002@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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


Attachment: jd.vcf
Description: text/x-vcard (640 bytes)

In response to

pgsql-odbc by date

Next:From: Greg CampbellDate: 2005-01-20 19:43:38
Subject: Re: How to call a stored procedure in PostgreSQL
Previous:From: Joost KraaijeveldDate: 2005-01-20 19:25:29
Subject: How to call a stored procedure in PostgreSQL

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