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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
