| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Andreas Joseph Krogh <andreak(at)officenet(dot)no>, "Atul" <atul(at)imcindia(dot)net>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Need Postgresql Help |
| Date: | 2002-12-02 10:57:09 |
| Message-ID: | 200212021057.09806.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian Gausepohl | 2002-12-02 16:39:03 | Analyzing the 7.3 SQL92 Schema |
| Previous Message | Atul | 2002-12-02 08:44:09 | Need Postgresql Help |