From: Richard Huxton <dev@archonet.com>
To: Andreas Joseph Krogh <andreak@officenet.no>
To: Atul <atul@imcindia.net>
To: pgsql-sql@postgresql.org
Subject: Re: Need Postgresql Help
Date: Mon, 2 Dec 2002 10:57:09 +0000
Message-ID: <200212021057.09806.dev@archonet.com> (raw)
In-Reply-To: <200212020942.42094.andreak@officenet.no>
References: <LHEOILFLDANINFJAGPEOIEFJCAAA.atul@imcindia.net>
<200212020942.42094.andreak@officenet.no>
On Monday 02 Dec 2002 8:42 am, Andreas Joseph Krogh wrote:
> On Monday 02 December 2002 09:44, Atul wrote:
> > Respected sir,
> > Atul Pedgaonkar here from India. I am using postgresql7.2 as
> > backend and for front-end, perl5.6.1. I need some help regarding
> > postgresql-stored procedure. The problem is like this
> >
> > 1)How to create stored procedure in postgresql?
> > 2)How can i use it from perl script with parameters. ?
> > 3)How to return resultset from that Stored Procedure ?
>
> You need 7.3 to do 3).
> Infor on stored procedures:
> $INSTALLDIR/doc/html/plpgsql.html
1. See the manual chapter on "procedural languages" - plpgsql, pltcl, plperl
Also see http://techdocs.postgresql.org
2. Exactly as with any other query
3. Either upgrade to 7.3 (as above) or return a cursor from the function.
--
Richard Huxton
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, andreak@officenet.no, atul@imcindia.net
Subject: Re: Need Postgresql Help
In-Reply-To: <200212021057.09806.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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