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