Quick Links

Re: How to call a stored procedure in PostgreSQL

Lists:	pgsql-odbc

From:	"Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To:	"Pgsql-Odbc (E-mail)" <pgsql-odbc(at)postgresql(dot)org>
Subject:	How to call a stored procedure in PostgreSQL
Date:	2005-01-20 19:25:29
Message-ID:	A3D1526C98B7C1409A687E0943EAC41048A0D6@obelix.askesis.nl
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-odbc

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...

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

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
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
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)

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	Content-Type	Size
jd.vcf	text/x-vcard	640 bytes

From:	"Greg Campbell" <greg(dot)campbell(at)us(dot)michelin(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:43:38
Message-ID:	41F009EA.6050401@us.michelin.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-odbc

Try "SELECT procedure-name(arg1, arg2)" as if it were a SELECT or INSERT
or UPDATE statement.
For example
if I have function named calc_square(int)
I could use "SELECT calc_square(2);"

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...
>
>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
>
>

Attachment	Content-Type	Size
greg.campbell.vcf	text/x-vcard	283 bytes

From:	"Greg Campbell" <greg(dot)campbell(at)us(dot)michelin(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:46:30
Message-ID:	41F00A96.3090104@us.michelin.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-odbc

Addendum
"SELECT procedure_name(arg1, arg2)" for NON-select non-data returning
queries
"SELECT * FROM procedure_name(arg1, arg2)" for SELECT queries

Joost Kraaijeveld wrote:

Attachment	Content-Type	Size
greg.campbell.vcf	text/x-vcard	283 bytes

From:	markw(at)mohawksoft(dot)com
To:	"Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
Cc:	"Pgsql-Odbc" <pgsql-odbc(at)postgresql(dot)org>
Subject:	Re: How to call a stored procedure in PostgreSQL
Date:	2005-01-20 19:54:05
Message-ID:	16399.24.91.171.78.1106250845.squirrel@mail.mohawksoft.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-odbc

> 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-name(arg1, arg2);